Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NULLS FIRST option in CREATE INDEX?
No artificial values or keys in the previous example.
It is just function-based index (FBI)which is provided by Oracle for
such reasons
(e.g. if you have in WHERE a function on the column). You will not
create an extra column on the table!!!
If is good or not to use FBI, I would not say Yes or No, depends on the situation. The original question was if that is possible in the index itself to have NULL FIRST, so I`m saying YES - by using FBI.
Jan
Brian Peasland <oracle_dba_at_remove_spam.peasland.com> wrote in message news:<3EF0775E.8E98D338_at_remove_spam.peasland.com>...
> Part of my point is that by using this method, whether it is 'AAA' or
> some other value, is not always a good thing to do. One ends up making
> artificial values mean things that they don't if taken for face value.
> This can lead to problems down the road. The same is true when
> introducing artificial keys, which people seem to do all the time.
>
> 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"
Received on Thu Jun 19 2003 - 02:59:02 CDT