Different execution time of query in two environment
I am using a SELECT COUNT query with several conditions in the WHERE clause. When I execute the query in the Dev environment, it completes in just a minute or less, but when I execute the same query in the Prod environment with same number of records, table structure and index, the query takes more than 1 hour to complete. What could possibly cause the slow execution in the Prod environment? Thank you.