Could you elaborate more on "function based indexes"? Thanks.
"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
news:3mmscvs04u6ph9mqiv2j342mb7r35fb09n_at_4ax.com...
> On Fri, 23 May 2003 16:40:12 GMT, "Craig Burkett"
> <cburkett_at_triad.rr.com> wrote:
>
> >Hi all,
> >
> >I need some guidance as to how best accomplish a case insensitive search
> >while still using indexes. One thing I was wondering was does PL/SQL
> >support regular expressions and can they be applied to existing indexes.
> >I'm trying to avoid having to rebuild indexes forcing them to using upper
> >case and I certainly don't want a function (ie UPPER) on the field side
of
> >the equation which would cause a table scan instead of an index search.
> >
> >Also does anyone know if Oracle 9i support a switch to use case
insensitive
> >comparisons?
> >
> >Thanks,
>
>
> Use function based indexes (available in EE only), or add a redundant
> column, indexed
>
> Why would Oracle 9i support case insensitive comparisons if there are
> function based indexes, and the world outside the Evil Empire (also
> known as Mickeysoft) didn't change to case insensitive.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri May 23 2003 - 12:35:11 CDT
