Create index on identifier attributes

[koenvo]

To increase performance of queries it can make sense to add indexes to the identifier fields.

CREATE INDEX idx_player_id_filter 
ON dataset (CAST((dataset.identifier ->> 'player_id') AS VARCHAR));