Re: Analyze Index and INDEX_STATS

Hi Dipen,
The answer is that Null keys are not stored in the index, which is in this case exactly what you want.
Validate structure addresses the physical structure only, not the logical.

Hth,

Sybrand Bakker, Oracle DBA

Dipen Kotecha <dkotecha_at_ford.invalid> wrote in message news:3793380B.F1397C07_at_ford.invalid...
> We have a field called CHANGED on a table, and it has only two values,
> '1' or NULL. When I use :
>
> SELECT index_name, distinct keys from user_indexes
> WHERE index_name = 'CHANGED_IDX';
>
> I get a value of 2 for the distinct keys, which is correct.
>
> But if I use ANALYZE INDEX CHANGED_IDX VALIDATE STRUCTURE;
>
> and then select distinct_keys from INDEX_STATS I get 934 for the same
> index!!
>
> Does the distinct_keys in INDEX_STATS refer to something else or am I
> doing something wrong?
>
> Any help would be greatly appreciated.
>
> Regards,
>
> Dipen Kotecha
Received on Mon Jul 19 1999 - 11:10:08 CDT