I have a Performance issue with one of my Select Query. The query completed around 2 sec in UAT and the same query completed around 1 min in PROD. The table structure, Indexes, statistics everything is same and up to date in both environment. When i check the execution plan in Prod the Execution plan shows Index Scan on one table, in UAT on the same table it has index seek.
Why the query execution plan not used index seek in PROD environment and how to change it?
Thanks in advance.