Urgent.News

What's breaking now, across thousands of outlets.

World

Dodgers clinch division title today, have '1' magic number even with Shohei Ohtani absent

Translated from Japanese Read in Japanese

The article discusses the issue of redundant indexes in databases, specifically focusing on MySQL. It explains that a redundant index occurs when a single-column index is included in a composite index, which can be unnecessary as the single-column index can be used for lookups that the composite index can also satisfy. The article provides a method to identify and remove these redundant indexes using MySQL's standard view `sys.schema_redundant_indexes` or tools like `pt-duplicate-key-checker` and `sys.schema_unused_indexes`.

It also highlights the importance of not removing redundant indexes that are part of a foreign key constraint, as doing so can cause an error. The article concludes by demonstrating a safe way to drop a redundant index using ActiveRecord migration.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

This story

This is one outlet's version. Read the fullest account.

Read the original at asahi.com →

More in World

More from Wednesday 16 September →