Here is my non Clustered Index:

Primary Key column is : [PLGID]

CREATE NONCLUSTERED INDEX [_dta_index_STOCK_5_877298235__K6_1_33_35_37_38_39_40_41_42_43_44_45_46_48_49_50_51_52_54_55_56_57_58_59_60_61_62_63_64_65_66_] ON [dbo].[STOCK]

(

[PLFTX] ASC

)

INCLUDE

(

[PLGID],

[PAQCO],

[PNARR],

[PLTRF],

[PORFY],

[PEXDT],

[PEXTM],

[PRFOR],

[PRFLN],

[PRFSL],

[PRFFY],

[PTRRE],

[PRESP],

[PTRCU],

[PTRSC],

[PTRRT],

[PERTY],

[PLHID],

[PMHID],

[PCHID],

[PETDT],

[PETTM],

[PDBCR],

[PIAMD],

[PEXVL],

[PXPDT],

[PLCVL],

[PORRV],

[POOHB],

[PNOHB],

[PRFID],

[PPLCD],

[PFRE1],

[PFRE2],

[PFRE3],

[PFRE4],

[PFRE5],

[PFRE6]

) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY].

I agree that all the column should not be part of index column. So i only choose the column to be indexed and rest columns are in INCLUDE . So there is some improvement around 20% improvement.

My question is that should i trim all those in the INCLUDE part. Is that will be helpful.

Thanks a lot for viewing my question and posting valuable answer. Please suggest if i can do any other thing.

Thanks & Regards,

Sashikanta Mishra.