Home Dashboard Directory Help
Search

[SSDT] SSDT doesent support hypothetical indexes by Dave_Ballantyne


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 772495
Opened: 11/28/2012 3:25:03 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

If i have a hypthetical index on my database:

Create index IdxName on TableName(ColumnName) with statistics_only

Firstly SSDT doesnt understand the syntax so i have to create it as non hypothetical.

Then when i publish to the database SSDT will generate the the create statement as if no index exists, causing an "INDEX ALREADY EXISTS" error when executed.

Details
Sign in to post a comment.
Posted by Microsoft on 12/3/2012 at 2:12 PM
Hi Dave,

Thanks for contacting Microsoft. We looked at your suggested but support for hypothetical indexes is out of scope for SSDT. Since they only provide statistical data and aren't real indexes, we won't be optimizing SSDT for this scenario.

Sorry for the inconvenience.
Sign in to post a workaround.