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 -> SQL: want to create index based on part of column value

SQL: want to create index based on part of column value

From: Jean-Pierre Dery <derj_at_copernic.com>
Date: Tue, 01 Jun 1999 20:38:52 GMT
Message-ID: <wxX43.69$PJ6.38654@client.news.psi.net> 





Hi,



how can I specify an index that indexes only the first 10 characters of a
column values ?



Something like "create index myindex on mytable(substr(mycolumn, 1, 10));" ?
Seems logical but it doesn't work.



Any ideas ?



Thx



Jean-Pierre Dery


Received on Tue Jun 01 1999 - 15:38:52 CDT












Original text of this message













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