Search

Create Index Automatically on FOREIGN KEY by Kalman Toth

Resolved
as Won't Fix Help for as Won't Fix

2
8
Sign in
 to vote
Type: Suggestion
ID: 767333
Opened: 10/13/2012 4:09:13 PM
Access Restriction: Public
0
Workaround(s)
Create Index Automatically on FOREIGN KEY for optimization purposes.

Provide option to DROP the automatically created index.

Exclude FOREIGN KEYs referencing small lookup tables such as currency table.
Details (expand)

Product Language

English

Category

SQL Engine

Proposed Solution

When FOREIGN KEY is created, engine should create the index automatically.

Primary Benefit

Improved Performance

Other Benefits

Increased lead developer & DBA productivity.

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 1/25/2013 at 4:22 PM
Given that this has been open for over 3 months and based on user votes (2 up and 8 down) we are closing this item and not making any changes.

If folks feel strongly, please re-open.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement