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;