Re: SQL performance tuning

From: James Williams <willjamu_at_mindspring.com>
Date: Thu, 14 Jun 2001 15:04:12 GMT
Message-ID: <3b28d1a2.48265934@nntp.mindspring.com>

On 13 Jun 2001 14:22:40 -0700, OFederov_at_hds-mckhboc.com (Oleg Fedorov) wrote:

Oleg,

I made your suggested changes. Get the same results.. I am about to look at some of the parms in the init.ora pertaining to the optimizer.

For grins and giggles I have added indexs to all columns except CD_SPEC_DT which only has 4 distinct values. Let me know if you guys see anthing else.

Thanks!

>Hi,
>
>First of all,
>
>SO.DT_SO_CMPLT is NULL or
>SO.DT_SO_CMPLT>to_date('20010501','yyymmdd')
>
>looks better(Oracle do not need to convert SO.DT_SO_CMPLT to char for
>each record and can use index for this field) then
>
>to_char(SO.DT_SO_CMPLT,'yyyymmdd') > '20010501' or
>to_char(SO.DT_SO_CMPLT,'yyyymmdd') is null
>
>If that's not enough let us know.
>
>Good luck,
>Oleg
>
>
Received on Thu Jun 14 2001 - 10:04:12 CDT