replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/

Source Link

edited Apr 13, 2017 at 12:42

1

I have run a database engine tuning advisor session database engine tuning advisor session, DTA, to optimize my database.

added 299 characters in body

Source Link

edited May 13, 2016 at 9:58

Marcello Miorelli

16.6k
53
170
311

This table currently does not have any other index , however the following index is appointed as missing:

CREATE NONCLUSTERED INDEX IDX_IconTypeID_Active_INC_1_2_3_4_5_6 
ON [dbo].[ProductIcon] ([IconTypeID], [Active]) 
INCLUDE (ClassID,SegmentID,GroupID,Tier1,Descr,Tier2)

This table currently does not have any other index , however the following index is appointed as missing:

CREATE NONCLUSTERED INDEX IDX_IconTypeID_Active_INC_1_2_3_4_5_6 
ON [dbo].[ProductIcon] ([IconTypeID], [Active]) 
INCLUDE (ClassID,SegmentID,GroupID,Tier1,Descr,Tier2)

changed the title - it is more clear and objective

Source Link

edited May 13, 2016 at 6:26

Marcello Miorelli

16.6k
53
170
311

are overlapping multi column stats contained in another multicolumn stats set - which ones to keepstatistics redundant?

Is there any way I can have this vision so that I can make my decision as to which one(s) of them I should keep?

Source Link

asked May 12, 2016 at 17:26

Marcello Miorelli

16.6k
53
170
311

Loading

Stack Exchange Network

Return to Question

are overlapping multi column stats contained in another multicolumn stats set - which ones to keepstatistics redundant?

multi column stats contained in another multicolumn stats set - which ones to keep?

are overlapping multi column statistics redundant?