siddartha pal (9/12/2009)

---

Hi

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]

(

[ID] ASC

)

And I have another index with as follows:-

CREATE NONCLUSTERED INDEX [IX_RQST_SID_RTypeID_RCrBy] ON [dbo].[RQST]

(

[ID] ASC

)

INCLUDE (

[RQSTTypeID],

[SystemID],

[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.

cheers

Siddarth