CheckTablesForIndex

Last updated: July 14, 2025

CheckTablesForIndex scans your target URL database tables to find tables which do not have an associated index.

Uses

Property

Value

Liquibase version required

4.19.0+

Scope (--checks-scope)

database

Default status

enabled

Default severity (exit code)

0 ("INFO")

Customizable settings

No (static)

Use the check to enhance deployment control by checking for an associated index that your target URL database tables uses. It is good practice to index your frequently read tables to improve performance by speeding up queries. This policy check, like other checks, can be configured with a severity level which returns an exit code designed to stop automated jobs, giving your team time to apply this Liquibase best practice.

Note: We find this check especially helpful when using Check Chains to link to a check which looks for tables with names in a certain pattern, such as ObjectNameMustMatch, and then looks for an index in those tables.

Before you begin

  1. Ensure that you have correctly specified your Liquibase Pro license key.

  2. Ensure that the --checks-scope parameter includes the scope of this check.

Changelog checks prerequisites

--license-key=<string>
--checks-scope=<string>

Procedure

1

Enable

This check is enabled by default. To verify that it is currently enabled, run the checks show command:

liquibase checks show --check-name=<string>

2

To run the check, use the checks run command.

liquibase checks run --check-name=<string>

Note: For flow files you'll need to run liquibase flow to apply your changes.

CheckTablesForIndex - Liquibase