There are models with columns that are used for queries and are not indexed There are wrong index types for long varchar columns (hashindex should be used) There are long varchar columns with unique constraint and btree index, should be hashindex