You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently Name_player is created with a unique index on (uuid, player) and no primary key. Instead, it should have a unique index on (uuid) to prevent duplicate UUID mappings, change the existing (uuid, player) index to be non-unique for supporting player lookups by uuids, and add a non-unique (player, uuid) index to facilitate uuid lookups by player name. The latter two are non-unique to speed up operations and because the UUIDs are always unique these entries will always be as well.
A primary key should not be used on this table because that would force record ordering. For random data like uuids, that would cause the table to be rebuilt often to create space for new rows in the ordering.
The text was updated successfully, but these errors were encountered:
Currently Name_player is created with a unique index on (uuid, player) and no primary key. Instead, it should have a unique index on (uuid) to prevent duplicate UUID mappings, change the existing (uuid, player) index to be non-unique for supporting player lookups by uuids, and add a non-unique (player, uuid) index to facilitate uuid lookups by player name. The latter two are non-unique to speed up operations and because the UUIDs are always unique these entries will always be as well.
A primary key should not be used on this table because that would force record ordering. For random data like uuids, that would cause the table to be rebuilt often to create space for new rows in the ordering.
The text was updated successfully, but these errors were encountered: