Block 2: Reading data, basic level, chapter 4: Lookup operators

Block 2: Reading data, basic level, chapter 4: Lookup operators

€ 24.95 € 24.95

Categories: , ,

Description

Content:
Operators covered: Key Lookup, RID Lookup for “standard” data.
What happens “under the hood” in these operators? Which properties to look at?
Misleading row count estimate when predicate is pushed down.
Avoiding lookups: considerations for clustered index choice; considerations for covering indexes.

View time: 36:11 (8:55 demos).

Reviews

There are no reviews yet.

Be the first to review “Block 2: Reading data, basic level, chapter 4: Lookup operators”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may also like…

Related products

Hugo Kornelis

Married, father of 2 children.

Awarded 18x MVP (2006-2016; 2019-now), in the areas SQL Server and Data Platform.

Subscribe via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archives

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close