| NAME | animals | index on animals |
| PRIMARY_KEY | biolife | primary key index on biolife |
| PRIMARY_KEY | country | primary key index on country |
| City | custoly | index on custoly |
| Names | custoly | index on custoly |
| PRIMARY_KEY | custoly | primary key index on custoly |
| PRIMARY_KEY | customer | primary key index on customer |
| ByCompany | customer | index on customer |
| ByName | employee | index on employee |
| PRIMARY_KEY | employee | primary key index on employee |
| Date_Time | events | index on events |
| PRIMARY_KEY | events | primary key index on events |
| ACCT_NBR | holdings | index on holdings |
| SYMBOL | holdings | index on holdings |
| IND_CODE | industry | index on industry |
| ByOrderNo | items | index on items |
| PartNo | items | index on items |
| PRIMARY_KEY | items | primary key index on items |
| GROWTHASC | master | index on master |
| SYMBOL | master | unique index on master |
| GROWTHDESC | master | index on master |
| CustNo | orders | index on orders |
| PRIMARY_KEY | orders | primary key index on orders |
| ByDescription | parts | index on parts |
| VendorNo | parts | index on parts |
| PRIMARY_KEY | parts | primary key index on parts |
| EventNo | reservat | index on reservat |
| CustNo | reservat | index on reservat |
| PRIMARY_KEY | reservat | primary key index on reservat |
| PRIMARY_KEY | vendors | primary key index on vendors |
| PRIMARY_KEY | venues | primary key index on venues |