Dear All ,
I have a hash sub partitioned on multiple columns for a table. Say sub partition by hash (column B, column C). Main partition is list on (column A).
Recently application introduced a query which is like,
Query 1:
Select * from TABLE_A
Where column A=201411
And column B =’MAUP’;
The above query 1 is not utilizing the sub partition and query execution is taking time.
Below is the earlier query which was benefitting partition & sub partition and this is running fine.
Query 2:
Select * from TABLE_A
Where column A=201411
And column B = ’MAUP’
And column C = ‘GHRV’;
Can you please share the possible solution to handle this scenario.
Thanks in Advance