cancel
Showing results for 
Search instead for 
Did you mean: 

Create index with included columns

Former Member
0 Kudos

How do you create a covering index within tran se11 to "include" columns. Do you create the index within SAP ABAP dictionary and then use SQL Server/database tools to then add the included columns? And if you do this will it removed during an upgrade or patch that alters that table?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Link is dead, Matt Peters is offline since 2010 ...

But there is a solution

Note 1775008 - Definition of index include columns for MSSQL server

Kind regards, Rudi

Answers (3)

Answers (3)

rob_moss
Explorer
0 Kudos

Apologies for the thread necromancy, but I was looking for an answer to this question and luckily Matt Peters' page was saved by the Wayback Machine in 2013:

https://web.archive.org/web/20130512100638/http://mattabase.com/archives/126

luisdarui
Active Contributor
0 Kudos

Hi Rob,

I was wondering whether you have checked for both SAP and Microsoft official documentation about how to create indexes with included columns.

From SAP side, the included columns are not part of DDIC so therefore they are not transported at all. SAP provide means to create included columns from within SAP NetWeaver so in case you don't need to go to SSMS and recreate manually an index adding included columns manually.

SAP Note https://service.sap.com/sap/support/notes/1775008 is definitely the way to go from within SAP software to create indexes with included columns and you have Books Online also: https://msdn.microsoft.com/en-us/library/ms190806.aspx

Best Regards,

Luis Darui

rob_moss
Explorer
0 Kudos

Unfortunately, method number one in SAP Note 1775008 doesn't actually work in most cases. The stuff you pass in gets ignored. Method number two works perfectly, however.

luisdarui
Active Contributor
0 Kudos

Yes, the first method has a bug in old BSP however it will be fixed within new releases. Meanwhile we have recommended customers to use the second method.

Best Regards,

Luis Darui

Former Member
0 Kudos

Go to link above to read how to get this accomplished.

Former Member
0 Kudos

Answered my own question here:

http://mattabase.com/archives/126