Re: Explain plan dilemma
From: Roger Snowden <snowden_at_haven.ios.com>
Date: 1995/07/19
Message-ID: <3ujlnd$qrl_at_news.ios.com>#1/1
Date: 1995/07/19
Message-ID: <3ujlnd$qrl_at_news.ios.com>#1/1
Mark Johnson (markjo_at_netcom.com) wrote:
[snip, snip]
Each time you run the 'EXPLAIN PLAN...' stuff, give statement_id a new name. Then the select looks more like:
... from plan_table
WHERE statement_id='Hoopla'
CONNECt BY PRIOR id = parent_id and statement_id='Hoopla'
START WITH id=1;
Where the EXPAIN PLAN looked like:
EXPLAIN PLAN
SET statement_id='Hoopla'
FOR
SELECT ... etc.
So that Hoopla is different each time you get an EXPLAIN.
Roger Received on Wed Jul 19 1995 - 00:00:00 CEST