Important Observations
- Indexes may have one or more key fields.
- Keys can be assigned as ascending or descending sequence.
- Numeric sequence can be signed, unsigned or an absolute value.
Tips and Techniques
- Indexes provide an efficient means to access a table in an alternative sequence.
What I Should Know
- How to create a index.
- How to define the keys to the index.
- How to rebuild the table when test data is present.