Indexes in ax

The advantages of indexes are as follows:

·         Their use in queries usually results in much better performance.

·         They make it possible to quickly retrieve (fetch) data.

·         They can be used for sorting. A post-fetch-sort operation can be eliminated.

·         Unique indexes guarantee uniquely identifiable records in the database.

The disadvantages of indexes are as follows:

·         They decrease performance on inserts, updates, and deletes.

·         They take up space (this increases with the number of fields used and the length of the fields).

·         Some databases will monocase values in fields that are indexed.