So currently I have a table that is
playerName:String (Partition)
playerAge:Number (Sort)
player_str_dex_int_luck:String (Local Secondary Index Sort Key)
I want to add a key to my table player_dex_str_int_luck:String to sort on while keeping playerName as my partition key.
I have to use a GSI for this since you cant create LSI after the table is made. Is there any difference between a GSI and LSI since I'm keeping the partition key of my GSI the same as that of the original table?