FreeLists / oracle-l / Re: SQL Tunning

[Edgar Chupit <edgar.chupit@xxxxx>]

Hello Wes,

WB>    WHERE TRUNC(last_update_date) = TRUNC(SYSDATE - 1)
WB> How to improve the performance?  Do I need to create a new index field on 
the table with TRUNC(last_update_date)?

You have several opportunities:
a) you can rewrite your query to this:
       where last_update_date between trunc(sysdate)-1 and 
trunc(sysdate)-1/86400
b) you can create function based index like:
       create index tt_idx on tt(trunc(last_update_date));
c) you can add column to your table with values from trunc(last_update_date)

What option to choose mostly depends on your requirements.

-- 
Best regards,
 Edgar                  

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------