Re: SQL Tunning

  • From: Edgar Chupit <edgar.chupit@xxxxx>
  • To: Wes Brooks <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 Aug 2004 13:24:49 +0300

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 
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,

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: