ANALYZE TABLE

    • table_identifier

      Specifies a table name, which may be optionally qualified with a database name.

      Syntax: [ database_name. ] table_name

    • { FROM | IN } database_name

    • NOSCAN

      Collects only the table’s size in bytes (which does not require scanning the entire table).

    If no analyze option is specified, both number of rows and size in bytes are collected.