OPT_ESTIMATE - Translate SEL$1 ...

Giganews Newsgroups
Subject: OPT_ESTIMATE - Translate SEL$1 ...
Posted by:  Helio Dias (heliovitor…@gmail.com)
Date: 20 Sep 2006

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

Replies