RE: Should we stop analyzing?

Mogens Nørgaard scribbled on the wall in glitter crayon:

> I'd like to know what practical and philosofical ideas you guys have
> on this topic.

i think a lot of this depends on the optimizer. i know the cost biased one has improved dramatically since it was introduced. and i thought that the purpose of gathering statistics was to enable the optimizer to pick the best and fastest execution path for each query at the time the query is being run. didn't the creation of outlines provide for those times that you wanted a set execution path for a query to persist? but then again i'm just a simple grunt DBA and may have all of this stuff wrong.
>
> Best regards - and Happy New Year,

and to you and the rest of the list as well. may you all have a year filled with good times, good friends and an open heart.

--
Bill "Shrek" Thater     ORACLE DBA      
"I'm going to work my ticket if I can..." -- Gilwell song
                william.thater_at_carrier.utc.com
------------------------------------------------------------------------
The best way to predict your future is to create it.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: William.Thater_at_carrier.utc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).