OH LORDY ... I'M STUCK FOR WORDS....
"Keith Langer" <tanalbit_at_aol.com> wrote in message
news:15c7b652.0303021747.2177140d_at_posting.google.com...
> I am trying to create a case insensitive index.
>
> Below is a test index:
>
> CREATE INDEX IDX_PERSON_FIRST
> ON PERSON(UPPER(FIRSTNAME));
>
>
> When I run it from my local user (schema owner) account, I get a
> permission problem. When I run it from the System account, it gets
> created. But then when I run EXPLAIN PLAN on the following query:
>
> select * from person where UPPER(FIRSTNAME) = 'MIKE';
>
> I still get full table scans.
>
> So what's going on here?
>
> Keith
Received on Mon Mar 03 2003 - 04:45:39 CST
