-1

In mysql with InnoDB storage engine, When create a multi column index, such as (a, b, c), how many B+ tree/B tree will be create?

Explain the detail if you can.

FisherMartyn
  • 826
  • 1
  • 8
  • 17

1 Answers1

1

InnoDB creates B+trees only. There is one tree for PRIMARY index. For every secondary index InnoDB creates one B+tee no matter how many columns are in the key.

See my slides with more examples https://twindb.com/efficient-use-of-indexes-in-mysql/

akuzminsky
  • 2,190
  • 15
  • 21