I have local db and I want to create index in table recording for artist_credit column for faster search.
My command
CREATE INDEX recording_idx_artist_credit ON recording(artist_credit);
But it doesn’t help. How can I create own indexes?
well, I installed db via mbslave (python project) and here recording.artist_credit is not index. Anyway, this command works for me, maybe it will be helpfull for someone else
CREATE INDEX recording_idx_artist_credit ON musicbrainz.recording USING btree (artist_credit)
1 Like