Beginner question -pardon me… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Beginner question -pardon me…

What is the default order for index creation?
If its ascending then how to create another index with descending order? Thanks.

Ascending is default, you can specify the order as :
CREATE NONCLUSTERED INDEX IndexName ON Tablename(ColumnName ASC, ColName2 DESC). _________
Satya SKJ

Just for reference, if you have an ascending index on a single column, there is no need to create a descending index on the same column as well. SQL server can traverse the leaf index nodes in both directions already. Adding a descending index is mostly useful when you have composite indexes. /Argyle