Re: Two different explain plans for same query

Originally posted by Francois
> We refresh the "test" from time to time by doing an import of the
> "live"export.

When you refresh using an import the index may end up much denser and much more clustered which may be enough to lure the optimizer into using it. The other question of course is: Did you analyze the table(s) in test after the import?
Check the table and index stats in both live and test and compare especially #leaf blocks and clustering factor.

--
Posted via http://dbforums.com