Re: Trying to safely compare user input name against database
[email protected] (Martin Evans)
| Newsgroups | perl.dbi.users |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
Larry W. Virden wrote: > On Tue, May 4, 2010 at 12:39 PM, Martin Hall <[email protected]> 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