Explain plan dilemma

From: markjo_at_netcom.com (Mark Johnson) Subject: Explain plan dilemma
Organization: NETCOM On-line Communication Services (408 261-4700 guest)

Hello,  

select lpad(' ',2*level)||operation||' '||options||' '||object_name from plan_table
where statement_id = '1'
connect by prior id = parent_id

    and statement_id = '1'
start with id = 1

    What is the problem here. This works fine if there are only statements with statements_ids of '1' in the plan_table. Otherwise it returns too many. The output looks something like the following.

  INDEX UNIQUE SCAN TABLES_UK1
  [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

--


|Fidonet:  Mark Johnson 2:283/618.99

|Internet: Mark.Johnson_at_p99.f618.n283.z2.fidonet.org

|

| Standard disclaimer: The views of this user are strictly his own.