What does the "wi" stand for in SQL Azure Automatic Index Naming?
1
vote
1
answer
1208
views
I have a SQL Database on Azure that is giving me a performance recommendation for an index.
What does the "wi" part of the name? I'm guessing something to do with the include part of the statement. With Include?
CREATE NONCLUSTERED INDEX [nci_wi_TableName_468BA2FCEC4455FB9A6ACA94430E4935] ON [dbo].[TableName] ([Id]) INCLUDE ([ColA], [ColB]) WITH (ONLINE = ON)
Asked by JC5577
(625 rep)
May 26, 2021, 12:03 PM
Last activity: Jun 15, 2022, 11:51 AM
Last activity: Jun 15, 2022, 11:51 AM