Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Function-Based Indexes and Dates

Function-Based Indexes and Dates

From: Gait, Christopher <cgait_at_condor.nrl.navy.mil>
Date: Sat, 20 May 2000 20:42:37 -0400
Message-Id: <10503.106163@fatcity.com> 





Does anyone know if there is a way (perhaps using stored functions) to get
function-based indexes to work with dates instead of character comparisons?
The only way I can get the optimizer to acknowledge a TRUNC(Date_Attribute)
index is to 1) use a hint and 2) Add a TO_CHAR, making it
to_CHAR(TRUNC(Date_Attribute)). This then messes up date comparisons from
the query since what is returned is no longer a date.
Received on Sat May 20 2000 - 19:42:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US