How to Work with a Local Database > Working with Indexes

Overview

An index is a data structure based of column values from a table and is used to quickly locate data without having to search every row in the table. MCL-Designer V4 allows you to organize the data contained in the local database tables into specific indexes.

The indexes you create are displayed in the "Indexes" section of the "Local Database" module. Since an index is based on a table, the "Indexes" section ONLY become visible after a table is added to the local database.

This topic includes the following:

Topic
Creating an Index
Duplicating an Index
Deleting an Index
Editing an Index