The Database Engine Tuning Consultant has suggested the development of some statistics for many in our queries. Works out that a few of these are identical only the column order differs within the CREATE STATISTICS command. For instance:

CREATE STATISTICS [StatName1] ON [dbo].table1

CREATE STATISTICS [StatName2] ON [dbo].table1

are these exactly the same or could they be treated in a different way?

Across the same lines can one mix CREATE STATISTICS command for any given table? When the Consultant suggested 3 different stats on a single column for 3 different queries can one perform a single create command for those 3 posts e.g.

CREATE STATISTICS [StatName1] ON [dbo].table1

CREATE STATISTICS [StatName2] ON [dbo].table1

into

CREATE STATISTICS [StatName1] ON [dbo].table1

Thanks

multiple stats on a single column are useless. Just one is required. order does not matter.