Re: OPT_ESTIMATE - Translate SEL$1 ...

Dear Daniel in resume, what i need is:

when i have a query like:

select t1.* from t1,t2,t3
where t1.col=t2.col and t1.col=t3.col and t2.col=t3.col

Oracle may generate a plan like
nest loop t1

      nest loop t2 t3

I Know a little bit about OPT_ESTIMATE eg: (TABLE, JOIN SCALE_ROWS)

What i want to know is how can i reference the second nest loop using @SEL at OPT_ESTIMATE like i saw in 10g profile.

Version 9i

DA Morgan wrote:
> Helio Dias wrote:
> > Hi, i want to know how to identify the subquery block using SEL$1
> > SEL$2 etc..
> >
> >
> > OPT_ESTIMATE(@"SEL$1", TABLE, "R"@"SEL$1", SCALE_ROWS=0.00664262176)
> > OPT_ESTIMATE(@"SEL$1", INDEX_FILTER, "R"@"SEL$1", PSAPSPRCSQUE,
> > SCALE_ROWS=0.0001556864475)
> > OPT_ESTIMATE(@"SEL$1", INDEX_SKIP_SCAN, "R"@"SEL$1", PSBPSPRCSQUE,
> > SCALE_ROWS=2.784763486)
> >
> >
> > 1238.pdf from Lewis (i had read)
> >
> > Thanks
>
> From what you have written I have just a few questions:
>
> 1. What product?
> 2. What version?
> 3. Where did this code come from?
> 4. What is it supposed to do?
> 5. What is the issue?
> 6. How does it relate to your question?
>
> The above does not contain any query much less a sub-query. It looks to
> be the predicate-filter information reported by DBMS_XPLAN and is, by
> itself meaningless.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group
Received on Wed Sep 20 2006 - 14:55:35 CDT