My oracle SQL query to retrieve records takes lot of time...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: [FAQ] Oracle Database FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Karthik M
Submitted on 6/15/2004
Related FAQ: [FAQ] Oracle Database FAQ
Rating:	Rate this question:
My oracle SQL query to retrieve records takes lot of time (5 mins) if order by clause is used. Without it,it takes only 3 seconds. Considering that lakhs of records have to be retrieved, how can we ensure sorted output with fast access.

Answer by Raghu Babu
Submitted on 7/6/2004
Rating: Not yet rated	Rate this answer:
Try using optimizers on the table u r querying the record. this should help the query perform better.

Answer by Paval
Submitted on 12/21/2004
Rating: Not yet rated	Rate this answer:
Use temperory tables and store records partially there and display it here.

Answer by gf
Submitted on 9/30/2005
Rating: Not yet rated	Rate this answer:
dfgdfg

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: