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 -> Re: When does performance worsen when going from RULE to COST

Re: When does performance worsen when going from RULE to COST

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 6 Feb 2000 09:26:29 -0000
Message-ID: <949829427.5738.0.nnrp-14.9e984b29@news.demon.co.uk>

You're talking about OUTLINES in 8.1.
But they work only on exact text matches at present.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Nuno Souto wrote in message <389cceb0.3721386_at_news-server>...
>
>Much better if ORACLE could come up with a way of "locking" an
>execution plan into the statement. That way, developers and tuners can
>lock-in what is the best way of doing the query (based on testing,
>educated guess, whatever) and stop worrying that next time the moon
>phase changes the performance is gonna go South...
Received on Sun Feb 06 2000 - 03:26:29 CST

Original text of this message

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