Subject Primary key not used in SELECT
Author kimon_the_athenian2

I have 2 databases with identical structure and different data. (But
the amount of data is approximately same)

I noticed that one query runs much slower in one of the databases and
it turned out that FB is not using primary key index of on of the
tables. When executing sama query in other DB the index was used.

When i backed up and restored the slow DB then it started to use PK index.

Are there some other options besides backup/restore to fix this kind
of problems? Sweeping did not help. And i suppose i can't make primary
key index inactive/active.

thanks in advance,