-
Needed DB Query optomized?
Hi All,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|