Oracle Database Discussions

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!

Gets and reads

847798Aug 5 2011 — edited Apr 17 2013

Dear all,

What is the difference between
"SQL ORDER BY GETS"
"SQL ORDER BY READS"

In the documentation i found that "GETS" = "LOGICAL READS" and "READS" = "PHYSICAL READS"

In oracle what is the difference between "PHYSICAL READS" and "LOGICAL READS"

Please help me regarding this.

Regards,
Vamsi.

This post has been answered by 782742 on Aug 5 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2013

Added on Aug 5 2011

#general-database-discussions

4 comments

1,804 views