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!

Explain Plan - Cost, Bytes , Cardinality

OraFighterOct 25 2011 — edited Oct 25 2011
I run almost same two query one without view , second without view
qury 1 -> select deptno , count(deptno) over (partition by deptno order by deptno ) tes from emp;
qury 2 -> select deptno,tes from(select deptno , count(deptno) over (partition by deptno order by deptno ) tes from emp)
where tes > 3 ;

I checked the explain plan of qry1 it gives Cost 4 Bytes 42 Cardinality 14
qry2 it gives Cost 4 Bytes 364 Cardinality 14

what it means what is this Cost , Bytes, Cardinality . only difference in Bytes is it dangerour..?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2011
Added on Oct 25 2011
6 comments
29,641 views