Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: published paper about indexing?

Re: published paper about indexing?

From: Anton Versteeg <anton_versteeg_at_nnll.iibbmm.com>
Date: Fri, 01 Aug 2003 10:46:25 +0200
Message-ID: <3F2A28E1.5060006@nnll.iibbmm.com>


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 Netherlands
Received on Fri Aug 01 2003 - 03:46:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US