Re: Explain Plan
Originally posted by balajiyes
Can some explain in brief wht each step is all abt?
Statistics
---------------------------------------------------
recursive calls
db block gets
consistent gets
physical reads
redo size
bytes sent via SQL*Net to client
bytes received via SQL*Net from client
SQL*Net roundtrips to/from client
sorts (memory)
sorts (disk)
rows processed
Very confusing subject title - I don't see any EXPLAIN PLAN (EXECUTION PLAN) at all. Those are statistics, not execution plan elements!
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?