Skip to content

Drop temp_index_on_notes_with_null_noteable_type from notes table

Mario Celi requested to merge 443667-remove-temp-index into master

What does this MR do and why?

The index was introduced temporarily to run a background migration on notes where noteable_type was null.

Now the NOT NULL constraint has been validated, we can DROP this index.

Because the index only matched rows with a null noteable_type, the index matches 0 rows now, so it should be very fast to drop

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #443667 (closed)

Edited by Mario Celi

Merge request reports