Search

[SSDT] SSDT doesent support hypothetical indexes by Dave_Ballantyne

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

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Not Applicable

Operating System Language

Not Applicable

Steps to Reproduce

As above

Actual Results

as above

Expected Results

as above

Platform

X64

Virtualization

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