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,
Copyright © 2021 Jogjafile Inc.
The default index is
btreeif you don't specify something else. You can use thecreateIndexentity to do this.Reference: Liquibase Documentation: createIndex