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).
