B-Tree index entails certain understanding in order for it to
work efficiently. Some pointers to be noted are:
• Matching an exact value
B-Tree index only works when matching an exact
value stored in a column and is used when there is
a WHERE condition
• Matching a leftmost prefix
Consider a following SQL query: