Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to update portion of the varchar type data
Hkgirlygirl wrote:
> if I index the column varchar(30) and
> when I select my data by using order
> by substr(item,4,3), will that do a table scan?
Yes. The index will not be used.
If you want an index on this portion of the explore using a function based index.
Daniel Morgan Received on Tue Dec 03 2002 - 10:52:40 CST