It depends on how smart the optimizer is - keep in mind the source of
the article. If the database optimizer can be aware of non-standard
distributions of values, as DB2's is, then indexing widely ranging
columns can be valuable. Same with static tables - indexes are very
valuable if index-only access is possible.
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?
Received on Fri Aug 01 2003 - 10:45:37 CDT
