Alexander Tabakov wrote:

>
> Thanks, I didn't think about that. But it is stil very strange because
>
> the primary index I talk about in the productional database has
>
> selectivity: 0,0000074... and after restoring it "drops" to
>
> 0,0000006....
>
>
>
> Instead of using it the optimize chooses to use a foreign key with
>
> selectivity of only: 0,00003... which is very strange to me.
>

Max selectivity is 1
so 0.00003 is bigger than 0.0000006

Daniele