Extending Index for Innodb tables can hurt performance in a surprising way

(Peter Zaitsev) One schema optimization we often do is extending index when there are queries which can use more key part. Typically this is safe operation, unless index length increases dramatically queries which can use index can also use prefix of the new index are they ? It turns there are speci

Read More - Register for Free Membership