Message
From
29/08/2016 05:55:51
To
29/08/2016 03:57:53
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01639951
Message ID:
01640116
Views:
55
>>>If I read that right then my supposition was correct ? :
>>>"Additional columns should be ordered based on their level of distinctness, that is, from the most distinct to the least distinct."
>>
>>In other words, from the most selective (e.g. column with many unique values) to the less selective (column with less values). This is how I understand it and this is what I said.
>
>You said: "If you have many categories and just few sites, then using Category as first column "
Right, this is how I understand the above sentence. Are you saying that my understanding is wrong?
>>>"Additional columns should be ordered based on their level of distinctness, that is, from the most distinct to the least distinct."
>>
>>In other words, from the most selective (e.g. column with many unique values) to the less selective (column with less values). This is how I understand it and this is what I said.
>
>You said: "If you have many categories and just few sites, then using Category as first column "
Right, this is how I understand the above sentence. Are you saying that my understanding is wrong?