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