Generate table statistics

After you initially load a table or any time the data of your table is changed, run the GENERATE STATISTICS command. This command ensures that your system has the most up-to-date information about the table, and thus creates optimal execution plans for any queries on that table.

To update statistics of the table, enter:
   MYDB.SCHEMA(USER)=> GENERATE STATISTICS ON emp;