I have a very basic query that creates different execution plans in production and test environments. Both environments have similar amount of data in the table and indexes are identical. I would preferably like to have the production server use same plan as the test server because it is more efficient. Any suggestions on how to achieve this would be appreciated. Thanks.