pmadhavapeddi22 (2/12/2014)
jeff,I have re written the query by joining the de norm table in from clause, but the no of
reads and cpu are high with the new query. Old query is showing low cpu and less no of reads. I also executed DTA for any new indexes but it showed no recommendations
Thanks
You can't trust the DTA. In fact, it misses lots and lots of tuning opportunities. Instead, read the execution plan of the query to understand the choices made by the optimizer in order to see where you might be able to influence those choices by restructuring your tables, your indexes, or, most of the time, your code.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning