Explain plan dilemma
From: Mark Johnson <markjo_at_netcom.com>
Date: 1995/07/15
Message-ID: <markjoDBqp9q.5AB_at_netcom.com>#1/1
Date: 1995/07/15
Message-ID: <markjoDBqp9q.5AB_at_netcom.com>#1/1
Hello,
select lpad(' ',2*level)||operation||' '||options||' '||object_name
from plan_table
and statement_id = '1'
What is the problem here. This works fine if there are only
INDEX UNIQUE SCAN TABLES_UK1
where statement_id = '1'
connect by prior id = parent_id
start with id = 1
[add 16 of the above line here]
INDEX UNIQUE SCAN TABLES_UK1
TABLE ACCESS BY ROWID TABLES (1)
INDEX UNIQUE SCAN TABLES_UK1
INDEX UNIQUE SCAN TABLES_UK1
Thanks
Received on Sat Jul 15 1995 - 00:00:00 CEST