Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ROWNUM & server performance
This is one case where i found the cardinality shown to be funny.
create table x as select rownum a from dba_users;
analyze table x compute statistics;
insert into x values(1)
Execution Plan
0 INSERT STATEMENT Optimizer=CHOOSE (Cost=2 Card=250 Bytes=750)
Xplan output
PLAN_TABLE_OUTPUT
regards
srivenu
Received on Fri Nov 11 2005 - 13:52:24 CST