Feature Request: missing composite indexes in various tables

[bandhan-majumder]

Is your feature request related to a problem? Please describe.

To make queries faster, we already have indexes in most of the tables. But few important of them are missing such as;

organizationMembershipts
chatMemberships
posts
comments
chatMessages

Describe the solution you'd like

Add the indexes and do a migration of the database

Describe alternatives you've considered

N/A

Approach to be followed (optional)

Add indexes
do migration

Additional context

N/A

[bandhan-majumder]

@palisadoes please assign

[bandhan-majumder]

@palisadoes few contributors added indexes for every column of some tables. For example: boolean fields with low cardinality, added read index where the operations are mostly write heavy. A lot of duplicate indexes. A lot of single indexes can be replaced by composite indexes or can be totally removed. Taking some reference from docs like this to understand what is actually needed. So, can I add those changes too in this PR ? (as the focus was just to add the missing, but later found that a lot of performance can be improve by removing the duplicated too). After doing some guess work on performance, around 20-30% storage can be freed which are currently occupied by duplicate indexes. Write can be 20% faster and queries can be faster upto 10%

[bandhan-majumder]

Made the changes, now finalizing it based on my understanding on the table indexes of how less/more frequently the data is being used.