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

Home -> Community -> Usenet -> c.d.o.server -> Making use of an Index with the rtrim function in the where clause

Making use of an Index with the rtrim function in the where clause

From: Prabhakar <srinivasharan_at_firsthealth.com>
Date: Tue, 02 Mar 1999 18:29:06 GMT
Message-ID: <7bhal7$7ou$1@nnrp1.dejanews.com> 





Hi!


 I am trying to use a column inside the Rtrim function in sql query's
where clause,I have an index for that column,I read from sql tuning
books that Oracle will not use the index if the column is embedded
within a function call like upper,is null etc.
How do I force Oracle to make use of that Index?...



Please do give me your valuable suggesstions on this.



Thanks in advance.



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Tue Mar 02 1999 - 12:29:06 CST












Original text of this message













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