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
