Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

interview question

874273Aug 3 2015 — edited Aug 5 2015

Hi Masters,

Just finished my technical interview from US. Only one question they asked me.

I have a select query which will work properly for retrieve the billion of records. But when I added order clause, the performance is the worst. Taking long time.

what are the scenarios you can resolve this problem?

Please advise..!! good for future ....!!!

Regards

Ar

This post has been answered by unknown-7404 on Aug 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2015
Added on Aug 3 2015
29 comments
2,782 views