April 24, 2013 at 8:01 am
Can an Index with a where clause be used to eliminate NULL values in the column and make the index more unique and effective.
April 24, 2013 at 8:05 am
Hi
Yes, an index can have WHERE clause, starting from sql server 2008 and upper versions (http://technet.microsoft.com/en-us/library/cc280372.aspx).
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
April 24, 2013 at 8:40 am
You can even create filtered statistics in a similar fashion to help the optimizer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2013 at 8:44 am
EXCELLENT!!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply