Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

Question

Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

OldCursor (2/25/2014)
Thanks Grant
Now . . . if you enjoy it so much perhaps you could pop round and sort out my clients problems - it would save all that studying.

Is that an open invitation? 😀

Execution plans and internals can be a load of fun.:cool:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Nice job Darren.

Nice clarifications by Grant.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

liver.larson SSC Veteran Points: 236 More actions · Answer 3

liver.larson

SSC Veteran

Points: 236

March 11, 2014 at 10:21 am

#1696058

second this.

Robert Sterbal SSChampion Points: 11046 More actions · Answer 4

Grant Fritchey (2/25/2014)

The Execution Plans book is free as a download from here[/url] if you don't want a paper copy.

Thank you!

412-977-3526 call/text

etheral1980 Old Hand Points: 303 More actions · Answer 5

When you wrote low selectivity maybe you meant high selectivity? It is when optimizer can decide to scan the index/table, because result set is large in % terms ?