The query is running from .net application. But when the application running in staging it is fetching the data immediately but in production it is giving us the below error:
When we run the query in SSMS in production it took 7mins.
------------
Server Error in '/' Application.
--------------------------------------------------------------------------------
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
----------------------------------------------------------------