Review the database scripts for the correctness and possible improvements

[madurangasiriwardena]

Describe the issue:
With the recent issues we have identified in the database indexes for the case-in-sensitive username use-cases, it is good to review the database scripts completely and confirm if they are in the best possible state at the moment.

[inthirakumaaran]

Lets validate this effort #21558 here as well