** RUNSTATS utility in DB2**

In IBM Db2, RUNSTATS is a utility used to collect and update statistics about database tables, indexes, and columns. These statistics help the Db2 optimizer make efficient query execution plans. Syntax: RUNSTATS ON TABLE schema.table_nameAND INDE...