Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-10-13 : 06:35:07
|
| My query is running slow, i have included index,defragmentation and tuning. but still performance not improved. i wish to know about the execution plan deep concept, any document which display all concept of execution plan. what to be and how to be.physical operation , logical operation ,estimated row sixe , i/o cost,cpu cost ,number of executes,cost,subtree cost,extimated row count |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 21:41:07
|
| Looked at books online? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-14 : 05:18:10
|
| I would recommend a good book , called "T-SQL Querying " by Itzik Ben-GamJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-10-16 : 02:41:32
|
| Yes looked online books .. general terms only mentioned.. not in depth. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 00:56:18
|
| So you got what those terms mean, just apply them when look at the plan. |
|
|
|
|
|
|
Execution plan