A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?