Filter out NULL values in Indexes

Received a great tip from my colleague on how to filter out NULL values in Indexes.

How to use a WHERE-clause within an Index? Well take a look!

CREATE NONCLUSTERED INDEX [IX_NC_ColumnName] ON [dbo].[TableName]
(
ColumnName ASC

)
WHERE ColumnName IS NOT NULL
WITH ...

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s