Last few days i have encountered a database issue that needed to optimize the queries. please assist me it would be really praised to you.
I am using on the joins on around 5-6 tables to fetch the data. and each of them have huge amount of data around in 10-50 millions. i got success to optimize the query following the indexing as hint. But the next issue is that we are unable to place the order by clause in query because it leads to machine halt.
Could you suggest me any radical approach in oracle 9i or later version.