Re: explain plan

Posted by ErmanArslansOracleBlog on May 30, 2024; 12:44pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/explain-plan-tp12529p12531.html

Note that

TABLE ACCESS STORAGE FULL DIM_CUSTOMER - This line shows a full table scan on the DIM_CUSTOMER table. Concentrate on that..

 253619     253619     253619                     TABLE ACCESS STORAGE FULL DIM_CUSTOMER (cr=111060598 pr=108746279 pw=0 time=814732681 us starts=31703 cost=111414 size=210 card=5)