What an index actually is

• A

  A copy of the whole table, sorted by email

• B

  A separate sorted structure of email values, each pointing at its row

• C

  A note telling the engine that it should search that column first

• D

  A cache of the most frequently searched emails