Originally posted by omegamark
I am sure if use Materialise view you will get good performance .Just give a try and see how it works ..
Hi Radha,

The performance is not that bad. Its only that i was wondering why is it not using the Function based indexes and is there any way to improve the query further.

Also the database is OLTP and i cannot use MV's for it bcos in the long run it will slow down the performance . Atleast thats what i think i have read. Coorect me if i am wrong.