Create Index Automatically on FOREIGN KEY - by Kalman Toth

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 767333 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/13/2012 4:09:13 PM
Access Restriction Public


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