CREATE NONCLUSTERED INDEX [IDX_LoadDate] ON Schema1.Object2 ( Column1 ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON Column3
By David Beaty 1 asked May 15 at 07:07 AM
This is an anonymized plan from Management Studio. We'll have much better luck digging into specifics if you can provide an actual plan generated within Plan Explorer and not anonymized if you can help it (anonymizing the plan forces us to disable the very useful Index Analysis feature, for example).
Not knowing any of the cardinalities or the primary key / clustered index on
You might also want to consider index tuning on
By Aaron Bertrand ♦ 1.7k answered May 15 at 02:14 PM