create index if not exists department_index
on department using btree (department_id);
How can I create a Liquibase changeset for the above Postgresql? I have to use "using btree" feature in order to attain the desired performance,
create index if not exists department_index
on department using btree (department_id);
How can I create a Liquibase changeset for the above Postgresql? I have to use "using btree" feature in order to attain the desired performance,
The default index is
btree
if you don't specify something else. You can use thecreateIndex
entity to do this.Reference: Liquibase Documentation: createIndex