How we can optimized it better

NM 2015-06-09 02:30:14

we need to fine tune the query to make it work with in 10 seconds. It is taking around 1 minute 10 second presently. Any advice recommendation would be highly appericiated.

Dean@SQLXL 2015-06-12 12:45:31
1. The command text has been anonymized however is looks like a very simple query that we want to see if we can get rid of the table scan. Can you post the query itself?
2. Something that jumps out right away as well is that the estimated rows and actual rows are very different. This lead me to believe the statistics on this table are out of date.
3. Can you tell me more about the table it is scanning? Primarily, how many rows?