Re: Cost based optimizer
Date: 1999/11/07
Message-ID: <LA6V3.20335$Ec1.213710_at_news1.frmt1.sfba.home.com>#1/1
YES. I use it.
ANALYZE TABLE mytable COMPUTE STATISTICS;
Then, to insure cost-based, over rule (perhaps the init file says "choose"
or "rule", you can
select /*+ FIRST_ROWS*/ * from mytable;
and oracle will use the statistics - of course, this is a meaningless
example, as it is only on JOINS, not single-table selects, where cost-based
optimization, absent indexes, etc. is likely to find the shortest execution
plan to the desired result set.
Todd Ryder
tryder2_at_home.com
Stanislav Benda <si_bendovi_at_hotmail.com> wrote in message
news:7vkflp$860$1_at_nnrp1.deja.com...
> Does anybody use cost based optimizer, hints, table statistics and
> histograms? It is at least 7 years old technology and seems to be
> ignored. I will appereciate any feedback.
> Please reply to me ( sender) as well,
>
> Stan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Nov 07 1999 - 00:00:00 CET