Home Dashboard Directory Help
Search

Documentation says filtered indexes automatically include primary key, that is incorrect by Tom Cooper


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 775841
Opened: 1/4/2013 3:45:41 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

The documentation (http://technet.microsoft.com/en-us/library/cc280372.aspx) states in the Limitations and Restrictions section: "The primary key of the table does not need to be a key or included column in the filtered index definition. The primary key is automatically included in all nonclustered indexes, including filtered indexes."

That statement is not correct.

As with all nonclustered indexes, the keys of the clustered index (if any) are included in each nonclustered index (whether filtered or not), but the primary key column(s) are not included unless they are in the clustered index.
Details
Sign in to post a comment.
Posted by Microsoft on 2/6/2013 at 8:29 AM
The correction now appears at http://technet.microsoft.com/en-us/library/cc280372.aspx. Thank you for submitting this.
Posted by Microsoft on 1/8/2013 at 11:01 AM
Thank you for submitting this. I'll take a look.
Sign in to post a workaround.