in which case reference partitioning is effective in enhancing performance in oracle 11g