Resolve "Remove ` index_users_with_static_object_token`"
requested to merge 429091-investigate-if-we-can-drop-index_users_with_static_object_token into master
What does this MR do and why?
We have introduced the index index_users_with_static_object_token
to help the performance of the EncryptStaticObjectToken
background migration.
This background migration was introduced in 2021.
Since we have already finished this background migrations, we don't need to have this index anymore.
Merge request where we introduced the index: !76684 (merged)
Index statement:
CREATE INDEX index_users_with_static_object_token ON users USING btree (id) WHERE ((static_object_token IS NOT NULL) AND (static_object_token_encrypted IS NULL));
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
Before | After |
---|---|
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #429091 (closed)
Edited by Diogo Frazão