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

---

]]>