sql - A covered index formed by a composite index or index with included columns -


Are there any differences between these two covered indexes?

  1. A composite index and UserID with both the buddy ID
  2. An index with FriendID and UserID as an included column

Different MS SQL Server related points If the answer to the above question is 'no difference' then is it or does the database engine tuning consultant (DTA) always go crazy on the included columns?

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -