Hi, I'm using the Oracle Version 11g on windows platform using Oracle Standard Edition.
I have Query that runs for the 6 hours to process million rows back. I'm trying to improved the query here.
My question is, once I created the index on four tables, the execution plan is still not using any of the new created indexes. So I'm trying to put hint here. Now how can i give hint to multiple tables indexes.
should i used the /*+ INDEX (Table_Name Index_name) */ for four table like this or there's another way to do it?