Skip to content

Commit 051c19a

Browse files
authored
Update sql-server-index-design-guide.md
1 parent 902b8d9 commit 051c19a

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/relational-databases/sql-server-index-design-guide.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -202,7 +202,7 @@ ON Purchasing.PurchaseOrderDetail
202202

203203
The [!INCLUDE[ssDE](../includes/ssde-md.md)] can move equally efficiently in either direction. An index defined as `(RejectedQty DESC, ProductID ASC)` can still be used for a query in which the sort direction of the columns in the ORDER BY clause are reversed. For example, a query with the ORDER BY clause `ORDER BY RejectedQty ASC, ProductID DESC` can use the index.
204204

205-
Sort order can be specified only for key columns. The [sys.index_columns](../relational-databases/system-catalog-views/sys-index-columns-transact-sql.md) catalog view and the INDEXKEY_PROPERTY function report whether an index column is stored in ascending or descending order.
205+
Sort order can be specified only for the key columns in index. The [sys.index_columns](../relational-databases/system-catalog-views/sys-index-columns-transact-sql.md) catalog view and the INDEXKEY_PROPERTY function report whether an index column is stored in ascending or descending order.
206206

207207
## Metadata
208208
Use these metadata views to see attributes of indexes. More architectural information is embedded in some of these views.

0 commit comments

Comments
 (0)