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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ROWNUM affects performance?

TurribeachFeb 5 2004 — edited Feb 11 2004

Does any one know if using the ROWNUM in a SELECT statement will have an impact on execution times (i.e. less time or the same) or will simply just be "clipping" the result set? So for instance, lets say we have a complex query that has many joins and takes X amount of time to retrieve the first result set. If the same query is used but with a clause of ROWNUM = 1, will this have a impact on X?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2004

Added on Feb 5 2004

11 comments

3,941 views