One of our application using an SQL query is reported running slow.
Current execution time:- 15 minutes and so
Earlier execution time:- 30 seconds.
I've checked for Fragmentation and stats if they are up to date. The weekend job for same executed successfully and seems OK for this point.
When I am using SQL-sentry plan explorer to check for the execution plan it shows me RED for a table going through clustered index seek and Green for Key Lookup.
I am new on how to analyse the plan.
Kindly advice on how to proceed and improve the performance of the query, thanks!