Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: published paper about indexing?
I think you are right.
I think the opposite , a column with only a few possible values like
'Y', 'N' would normally not
be a good candidate for indexing. But it all depends on the usage of the
data of course.
AK wrote:
>Hi Blair,
>
>regarding this paper:
>
>
>
>>http://www.oracledbaexpert.com/rdbms/indexing.html
>>
>>
>>
>
> I would not agree to this:
>
>What not to Index
>
>2. Static tables.
>3. Columns with a wide range of values.
>
>for me this sounds incorrect.
>
>What do you think?
>
>
-- Anton Versteeg IBM Certified DB2 Specialist IBM NetherlandsReceived on Fri Aug 01 2003 - 03:46:25 CDT