Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OPT_ESTIMATE - Translate SEL$1 ...

OPT_ESTIMATE - Translate SEL$1 ...

From: Helio Dias <heliovitorio_at_gmail.com>
Date: 20 Sep 2006 06:08:13 -0700
Message-ID: <1158757693.324259.246900@m7g2000cwm.googlegroups.com> 





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
Received on Wed Sep 20 2006 - 08:08:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US