REP006 - Indexes
Indexes are used to create alternate ways of organizing or accessing the data in your LANSA tables. You can create table sorting sequences that differ from the keys used in the physical table.
- To show how index views are created over existing tables to access the table data in an alternative sequence.
- To add an Index over the iiiDepartments Department table to sequence the table by iiiDeptDescription.
- To add an Index to the iiiEmployees table to sequence the table by iiiDeptCode.
To achieve these objectives, you will complete the following:
Step 1. Add an Index to Department Table
Step 2. Create Departments Test Form
Step 3. Execute Search by Description Form
Step 4. Add an Index to Employee Table
Before you Begin
In order to complete this exercise, you must have completed the previous exercises.