on 09-17-2009 5:39 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Go to link above to read how to get this accomplished.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answered my own question here:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.