Introduction to SQL Server Query Optimization

Functions in Filters and Joins

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This video discusses functions and how their inclusion in filters and joins can harm query performance, as well as how to adjust queries to maintain functionality and not incur this penalty.

Keywords

  • Query Optimization
  • Functions
  • User-Defined Functions
  • Join Clause
  • Filter Clause

About this video

Author(s)
Edward Pollack
First online
28 June 2019
DOI
https://doi.org/10.1007/978-1-4842-5144-7_10
Online ISBN
978-1-4842-5144-7
Publisher
Apress
Copyright information
© Ed Pollack 2019