419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> |
About Greg: https://about.me/greg.low
From: Tony Wright via ozdotnet
Sent: Monday, 10 October 2022 10:27 AM
To: ozDotNet
Cc: Tony Wright
Subject: SQL server composite key column order
Hi peeps,
When s
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