![]() Note: YAML and JSON changelogs using the column tag must nest it within a columns tag. The tablespace in which you create the index. The name of the table for which to add the index. ![]() The attribute that creates a clustered index. liquibase update Available attributes Name Step 2: Deploy your changeset by running the update command. Step 1: Add the createIndex Change Type to your changeset with the needed attributes as it is shown in the examples. To create an index on the existing column or set of columns, follow these steps: These changesets will produce the following (the update-sql command example): CREATE TABLE partment (col_1 INT, col_2 INT, col_3 INT) ĬREATE INDEX index_one ON partment(col_1, col_2, col_3) ĬREATE INDEX index_two ON partment(col_3, col_2, col_1) ĬREATE INDEX index_three ON partment(col_2, col_3, col_1) Running the createIndex Change Type ![]() When creating indexes, Liquibase uses the order of columns that you list in the createIndex Change Type. If you set the clustered attribute to false, Liquibase will create a non-clustered index, where the order of the rows will not match the order of the actual records. If you set the clustered attribute to true, Liquibase will create a clustered index, which defines the order in which records are stored in a table. You can typically use the createIndex Change Type when you want to add an index on one of the columns or a set of columns to increase the searchability of the records in your database. The createIndex Change Type creates an index on an existing column or a set of columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |