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 |
|
ElCapitan
Starting Member
28 Posts |
 Posted - 2009-02-11 : 08:44:29
|
| Hi all,I would like to find out the 'make up' of a good sql server execution plan. for example the presence of Nested loops over Hash Joins, and Seeks rather than scans etc. I know that it is not as simplistic as this and I have done much reading, however, any extra help will be greatly appreciated.Also, I have a plan at the below link...http://www.itshapes.com/ep/ep1.jpgIs it possible to tell from this plan if it seems an efficient plan, if it is too big of a plan (too many logical joins) etc. Also, what should I look for in the plan that highlights overall performance.Thanks for your time and help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 09:05:19
|
Seems like a good plan to me.But just to be sure, what is Lookup value in tooltip popup for all the "Clustered Index Seek".If the value is 1, it is a disguised bookmark lookup.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-11 : 09:16:26
|
| http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/--Gail ShawSQL Server MVP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 09:19:08
|
Grant Fitchey have written a good guide herehttp://www.amazon.com/Dissecting-SQL-Server-Execution-Plans/dp/B0018PCIFG/ref=ed_oe_k
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ElCapitan
Starting Member
28 Posts |
Posted - 2009-02-11 : 09:41:14
|
| Hi. Thanks for your help.Peso, I hover over the Clustered Index Seek and can see any title that says 'Look Up Value'. Would it be called something else? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 09:45:54
|
I think you are on the safe side then.Spend some time on Gails page and read about execution plans.Or pay 10 USD and buy the ebook from Amazon. It is well spent money.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Efficient Execution Plans?