Home Dashboard Directory Help
Search

Create Index Automatically on FOREIGN KEY by Kalman Toth


Status: 

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)
view

Description

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
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.