Table
|
Index name
|
Index column(s)
|
Primary
|
Unique
|
Customer
|
cust-num
|
cust-num
|
YES
|
YES
|
–
|
Why the index is defined:
![]() ![]() ![]() ![]() |
|||
name
|
name
|
NO
|
NO
|
|
Why the index is defined:
![]() ![]() |
||||
zip
|
zip
|
NO
|
NO
|
|
Why the index is defined:
![]() ![]() |
||||
Item
|
item-num
|
item-num
|
YES
|
YES
|
–
|
Why the index is defined:
![]() ![]() ![]() ![]() |
|||
Order-line
|
order-line
|
order-num
line-num
|
YES
|
YES
|
–
|
Why the index is defined:
![]() ![]() |
|||
item-num
|
item-num
|
NO
|
NO
|
|
Why the index is defined:
![]() |
||||
Order
|
order-num
|
order-num
|
YES
|
YES
|
–
|
Why the index is defined:
![]() ![]() ![]() ![]() |
|||
cust-order
|
cust-num
order-num
|
NO
|
YES
|
|
Why the index is defined:
![]() ![]() ![]() |
||||
order-date
|
order-date
|
NO
|
NO
|
|
Why the index is defined:
![]() |