Community

Visualizing the impact of ordered vs. random index insertion in InnoDB

(Jeremy Cole) Many DBAs know that building indexes in “random” order (or really any order that greatly differs from ordered by key) can be much less efficient. However, it’s often hard to really understand why that is.

Read More - Register for Free Membership