Add index on password_policy_history to reduce update hook execution time

Added index for the password_policy_history to fix the slow query which is taking 10 to 15 secs when the records are almost 4M.

After indexing the above query executes in less than 1sec.

It will also fix the update hook added in 📌 Create hook_update to remove duplicated entries in password_policy_history Fixed .

This hook is being updated here:

🐛 [ansi-sql compliant updates] - postgresql/mssql/mysql/sqlite password_policy_update_8304 Needs review

to just delete directly. Given this index will be added later (after that update hook runs), we need justification beyond the update hook to add the index. Moving to postponed for now.

Hello @kristen-pol,

The above issues will solve by removing the duplicating entries for one time.
But if we add index to the fields then running the delete query when there are more records which was almost 4 to 5 million records will be completed in 1sec. But when same query running without index for the fields then it was taking 15 to 20 secs which was getting reported in our slow query logs.

Please let me know if there is anything wrong in the approach.

Thanks
Siva Karthik