Re: How can I do create an index on expression ?

Invest in Oracle 8.1.5 or above, and read the manuals regarding function-based indexes. Short story is:

CREATE INDEX blah ON emp (UPPER(ename));

If you want to get mathematical, something like

CREATE INDEX blah2 on emp (sal*0.1);

Regards
HJR "luba_at_usb" <luba_at_usb.ua> wrote in message news:94ju9e$5q0$1_at_news.ukrsotsbank.com...
> How can I do create an index on upper(name) ?
>
> How can I do create an index on expression ?
>
>
>
>
> Roy Brokvam <roy.brokvm_at_conax.com> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:Hf_a6.327$2i6.5014_at_news1.oke.nextra.no...
> > Hi,
> >
> > select name from user where upper(name) = 'JOHN'
> >
> > If you need quick access via an index, create an index on upper(name)
> > instead of name.
 

> >
> > --
> > Roy Brokvam
> >
> > Hitchhikers against spam! Correct my last name to e-mail me.
> >
> >
> > pluto wrote in message <94hbb7$5fbm$1_at_stargate1.inet.it>...
> > >How i can make Oracle 8i case insensitive?
> > >
> > >Ex.:
> > >select name from user where name = 'john'
> > >
> > >equal to
> > >
> > >select name from user where name = 'JOHN'
> > >
> > >Thancks
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Jan 23 2001 - 02:58:15 CST