Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL performance tuning
On 13 Jun 2001 14:22:40 -0700, OFederov_at_hds-mckhboc.com (Oleg Fedorov) wrote:
>
>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
Bingo!
Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html
Received on Thu Jun 14 2001 - 06:31:41 CDT