Sample Header Ad - 728x90

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