I got the following recommendation on a table:

CREATE NONCLUSTERED INDEX [dta_index_MyTable_6_44943632__K16_K52_K8_K9_K15_1_2_4_5_6_7_10_11_12_13_14_17_18_19_20_21_22_23_24_25_26_27_28_29_30_31] ON [dbo].[MyTable] ( [ColumnA] ASC, [ColumnB] ASC, [ColumnC] ASC )

However, I am a bit surprised about the order of the fields in the recommendation. I would expect the result to be ColumnB, ColumnA, ColumnC.

Can I rely on the recommendation or should I decide the order of the fields?