Indexes - ERDL Diagram Syntax
- Use INDEX keyword to specify the column is an INDEX
- To define a composite INDEX, use the table level INDEX() syntax
Order
-
OrderID int INDEX
CustomerID int
TotalAmount money
OrderStatusID int
(or)
Order
-
OrderID int
CustomerID int
TotalAmount money
OrderStatusID int
INDEX(OrderID, CustomerID)
Post Comment