Hi!
A table already has a index on three columns (date_as_of,Brch_code,Porft_no) and partition on branch. To improve the performance took an export and created a new partitioned the table,imported the data and created some additional index on the date_as _of column for different quarters.
When the users query on the date_as_of columns its talking a long time. The record count in the table is 14680309
Cheers!