Re: EXPLAIN PLAN madness!

On Sat, 17 Nov 2001 12:35:18 GMT, nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote:

<snip>

>Plans being cheaper are not necessarily an indication they will
>execute faster. There is another concurrent thread to this one where
>you'll find an example of just that. The cost "advertised" by the
>EXPLAIN PLAN is not an absolute cost.
>

OUCH!!! I didn't know that. That puts a real crimp in things. I am looking at some additional indexes, was planning on using the plan cost as an assesment of their impact . . . . I know that plan cost is a bit of a synthetic number, but if you can't use relative values (plan A with a cost of 250000 vs plan B with a cost of 250) to select the best course of action . . . . where does that leave us?

<snip>
>
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)