Indexes

Indexes are set up on the Indexes tab of the table's property page.  

How do I open an object's Property Page?

Each index is defined as a set of one or more columns.  Indexes help to improve database performance.

Tell me more about the purpose of database indexes.

Name:

Make sure that you select a name that is valid for the database platform that you are using.

Columns:

Select one or more index columns.  Some databases allow you to specify the sort order of each column (Ascending or Descending).

Index Properties (Primary Key, Ignore Nulls, Unique & Clustered)

Related Topics:

• Database Basics - Indexes

• General Table Properties

• Columns

• Constraints

• Triggers

• Foreign Keys

• Database Basics

• Database Tools