Re: NULLS FIRST option in CREATE INDEX?

Provided COL2 can never contain 'AAA'. But what happens if requirements change in the future and 'AAA' is an allowable value?

Cheers,
Brian

Jan wrote:
>
> Look for Function-Based Index,
>
> you can do something like:
>
> create index my_index on my_table(col1,NVL(col2,'AAA'));
>
> Jan

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"