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
btreeif you don't specify something else. You can use thecreateIndexentity to do this.Reference: Liquibase Documentation: createIndex