Adding index for the pph fields

Closes #3319607

password_policy_history/password_policy_history.install

@@ -67,3 +67,12 @@ function password_policy_history_schema() {
   ];
   return $schema;
 }
+
+/**
+ * Add index for the fields of password_policy_history.
+ */
+function password_policy_history_update_10001() {
+  $database = \Drupal::database();
+  $pp_history = "ALTER TABLE password_policy_history ADD INDEX pph_timestamp (timestamp), ADD INDEX pph_hash (pass_hash), ADD INDEX pph_uid (uid)";
+  $database->query($pp_history);
+}