Hi peeps, When setting up composite key indexes in SQL server, I have always thought that it is best to put the column that has the most variation first in the index. I've recently seen articles that claim this is a myth.
So does anyone know the the facts here? Is column order important? Regards, Tony