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 -> to_char( ) column indexable

to_char( ) column indexable

From: Steve <schen_at_prodigy.net>
Date: 9 Feb 1999 00:40:26 GMT
Message-ID: <01be53c4$fd01c680$97899cd1@schen> 





Hi,



In the query 


"select a, b from XYZ where to_char(cid) = :d1",
the cid index is not used due to to_char function.       Has anyone indexed
on to_char(column) to do the query, or any other way around?



Thanks.



Steven
Received on Mon Feb 08 1999 - 18:40:26 CST












Original text of this message













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