CheckTablesForIndex

Last updated: January 22, 2026

Identifies database tables which lack indexes, highlighting potentially performance problems before they cause production slowdowns as data grows, ensuring efficient querying, joining, and constraint enforcement.

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)

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 Secure license key.

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

Changelog checks prerequisites

loading

loading

loading

loading

loading

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.

loading

loading

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