Btree indexing uses the contents of the entire column as an index key. For instance, in a Btree indexed company name column, the complete company name constitutes an index entry.

Use BTree Indexes when:

  • a search usually includes the entire contents of the column, such as for ZIP codes, dates, etc.;
  • you want to speed sorting on a column.

Searches on portions of an indexed column (such as part of a name) are possible, but may be slower than using a Cross Reference index (see the following section).

  • No labels