CREATE NONCLUSTERED INDEX [INDEX_CHANNELCODES_NAMECODETYPE] ON [dbo].[ChannelCodes] ( [Name] ASC, [CodeType] ASC ) INCLUDE ( [Id], [Code])