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

Home -> Community -> Usenet -> c.d.o.misc -> Indexes with substr

Indexes with substr

From: mpinzuti <mpinzuti_at_virgilio.it>
Date: Fri, 21 Sep 2001 09:34:29 +0000 (UTC)
Message-ID: <3B6A9171000245EB@ims2a.cp.tin.it> 





I'd like to know whether the function SUBSTR() on a field uses the index
eventually defined on that column.



Thanks in advance











-- 
Posted from vsmtp4.tin.it [212.216.176.224] 
via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Fri Sep 21 2001 - 04:34:29 CDT












Original text of this message













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