Sunday, February 19, 2012

execution plans

Hi

Can you give me sone pointers to where I can get more information about
the various operations like index seeks,Bookmark Lookups,Clustered
Index Scan in an execution plan.

Thanks

Ragu"Ragu" <ragudba@.gmail.com> wrote in message news:<1109642374.272240.212000@.f14g2000cwb.googlegroups. com>...
> Hi
> Can you give me sone pointers to where I can get more information about
> the various operations like index seeks,Bookmark Lookups,Clustered
> Index Scan in an execution plan.
> Thanks
> Ragu

Hi Ragu
Have you searched BOL extensively? The book 'Inside SQL Server' is
also a very good reference.|||Ragu (ragudba@.gmail.com) writes:
> Can you give me sone pointers to where I can get more information about
> the various operations like index seeks,Bookmark Lookups,Clustered
> Index Scan in an execution plan.

Books Online, in the book Optimizing Database Performance->Query Tuning->
Analyzing a Query->Logical and Physical Operators.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

No comments:

Post a Comment