Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?

A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.
C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.

Answer: B

0 comments: