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!

explain plan questions

RobeenJul 27 2018 — edited Mar 6 2019

Oracle Database 12.2.0.1

RHEL 7.4

Hi,

I am doing some tests on sql query

If I do select count(*) from dba_data_files, it returns 4. If E-Rows is 4 for NESTED LOOPS, it means it has looped once for all rows.

Why is E-Rows 49 for FIXED TABLE FULL, 55 for FIXED Table fixed INDEX?

Regards,

Joe

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2018

Added on Jul 27 2018

#general-database-discussions

7 comments

343 views