I have a table RQST with the primary key on Column ID. The Index automatiicaly created is
CREATE UNIQUE CLUSTERED INDEX [IX_RQST] ON [dbo].[RQST]
And I have another index with as follows:-
CREATE NONCLUSTERED INDEX [IX_RQST_SID_RTypeID_RCrBy] ON [dbo].[RQST]
[RequestCreatedBy]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
Is that a duplication of Index? if yes then how.
I need to have a Covering index so that data can be fetched from index directly instead of table.