Functions and Missing Indexes - SQL in Sixty Seconds 204

In this video, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance, especially when used on a column in the WHERE clause. However, we will explore even further to understand the significant impact on query hints.

0:00 Intro
0:14 Storytime
0:36 Demo: Functions and Missing Indexes
1:48 Afterthoughts

Join this channel to get access to perks:

#SQLServer #PerformanceTuning #SQLAuthority

[addisu_lemma]

I have benefited a lot from your resources over the years Pinal, thank you! Subscribed!

[frankzelazko]

Thank you for your yet another very educational video. Well done!

[gareth]

But in this example the YEAR() function didn't affect performance did it?

[arunkumarperumal]

why you are not uploading videos frequently now a days sir?.pls upload more videos.

[techpulse]

How we can backup and restore multiuser database in sql 2014

[felipedsleite]

That's Great! but how to "fix" it? Don't use functions? Create the missing index? Thanks! =)

[SwatiGuptaK]

I always avoid functions in the where clause. However, " What's the impact if the column is indexed"