Ivan Prenosil wrote:

>>Max selectivity is 1
>
>
>>so 0.00003 is bigger than 0.0000006
>
>
>
>
> The lower the value the better ...
>
>

Excuse me Ivan...

Selectivity is
SingleRowInTable / TotalRows

In PK this is 1 and index has the better selectivity

when SingleRowInTable become < TotalRows then selectivity decrease --> 0
so bigger values (near 1) are better for selectivity.

I'm wrong?

Daniele