Loading...

Seeks and Scans – Nudging the Optimizer in the Right Direction by Itzik Ben-Gan

2,146 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 7, 2015

Sometimes the query optimizer does a good job at optimizing certain query elements. However, there are cases where it doesn’t have the logic to handle certain query elements in the truly optimal way. In those cases you can intervene and nudge the optimizer in the right direction by applying query rewriting techniques. This session focuses on suboptimal choices made by the optimizer related to seeks and scans, and provides efficient solution in those cases.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...