I need to understand what is the best practice for me for a Simple Order Entry System.
My Table has two important columns.. Order Number &
DATE (When order was placed)
My Order Number is ALWAYS unique so i made it Primary key, there are many others tables which join to this table using Order Number.
Now I use DATE field to return sales within a Date Range...say jan - march orders.
My question is should I change the Primary Key Default Clustered Index on OrderNumber to Primary Key
NON CLUSTERED INDEX and then Change DATE to a CLUSTERED INDEX? i want fast performance..please keep in mind orders tables connects to many orders tables and they are joined together by using "Order Number" Column.
Thanks in advance
View Complete Post