Search

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

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)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Documentation

Operating System

Not Applicable

Operating System Language

US English

Steps to Reproduce

Go to help page http://technet.microsoft.com/en-us/library/cc280372.aspx

Actual Results

N/A

Expected Results

N/A

Platform

 

Virtualization

 
File Attachments
0 attachments
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.