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