How create own indexes in database?


#1

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?


#2

That command has been run by InitDb script already, if you installed the server.


#3

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)