Re: Explain plan dilemma

From: PKelley772 <pkelley772_at_aol.com>
Date: 1995/07/23
Message-ID: <3ustss$3er_at_newsbf02.news.aol.com>#1/1

Try

select lpad(' ',2*level)||operation operation, options, object_name from plan_table
start with id = 0 and statement_id = '1' connect by prior id = parent_id and statement_id = '1' Received on Sun Jul 23 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: RAC: "Re: Stack Overflow Error, Personal Oracle, help!"
Previous message: Shiraz Kanga: "Re: Oracle -> DBASE .DBF file possible?"
In reply to: Mark Johnson: "Explain plan dilemma"
Next in thread: RAC: "Re: Stack Overflow Error, Personal Oracle, help!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message