Advertisement
RockField64

SQLIndex

Oct 11th, 2021
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.18 KB | None | 0 0
  1. CREATE INDEX ix_Customers
  2. ON Customers (CustomerID, Cust_Name);
  3.  
  4. CREATE INDEX ix_Orders
  5. ON Orders (ItemID, CustomerId, OrderID);
  6.  
  7. CREATE INDEX ix_Items
  8. ON Items (ItemID, ItemName);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement