> > 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

The lower the value the better ...

Ivan