Re: stored outlines used but wrong plan executed

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 19 Sep 2004 17:02:38 +0000 (UTC)
Message-ID: <cike3e$2te$1@hercules.btinternet.com>

Note in-line

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message
news:414dabf0$1_at_post.usenet.com...


> **** Post for FREE via your newsreader at post.usenet.com ****

>

> (AFAIK the CBO doesn't use the timestamp of

> the objects like the RBO does to make a choice in case of equivalency, I'm

> wrong?).



    Correct - as far as indexes are concerned, it uses
    alphabetic order of name to break ties.

Received on Sun Sep 19 2004 - 12:02:38 CDT