Re: OPT_ESTIMATE - Translate SEL$1 ...

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