Re: Need help with cost based optimizer "logic"

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 12 Apr 2005 08:55:22 -0700
Message-ID: <1113321096.673173@yasure>

Syltrem wrote:

> "Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> a écrit dans le message de
> news:1113317629.6036914f3560cecbc6980b78fcdc04a3_at_teranews...
>

>>Try a functional index:

>
>
> I could, but still I would like to understand what the optimizer is doing

Then run a 10053 trace but I doubt you'll learn anything other than the fact that you could have saved a lot of time building a FUNCTION BASED index.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Apr 12 2005 - 10:55:22 CDT