Re: How I can create a function-based index ?

A copy of this was sent to Mario Bucsics <mario.bucsicsNOugSPAM_at_siemens.at> (if that email address didn't require changing) On Wed, 22 Sep 1999 00:36:40 -0700, you wrote:

>
>Why would you try to create such an index ?? this does not
>make sense. If you omit the UPPER function the index will
>be created.
>
>

makes greate sense to speed up queries such as:

select * from emp where upper(ename) = 'KING';

or

select * from emp where sal+comm > 500;

Oracle8i, release 8.1 i can in fact

create index idx1 on emp(upper(ename)); create index idx2 on emp( sal+comm );

that is -- index functions. To see how/why you might want to do this, visit the URL in my signature.

>
>
> Mario Bucsics
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Sep 22 1999 - 10:24:07 CDT