Larry W. Virden wrote: > On Tue, May 4, 2010 at 12:39 PM, Martin Hall <martin.h...@oracle.com> wrote: > >> But, you can create function based indexes, which will avoid full table >> scans. >> > > What is a function based index?
create index mycolumn_upper_idx on mytable(upper(mycolumn)); Do a search on the web for oracle function based indexes. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
