You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET table that contains detailed information about all the products. You gathered the table statistics and executed the following statements to find more information about this table:
SQL> SELECT chain_cnt,
2 round(chain_cnt/num_rows*100,2) pct_chained,
3 avg_row_len, pct_free, pct_used
4 FROM user_tables
5 WHERE table_name = ‘PROD_DET’;
CHAIN_CNT PCT_CHAINED AVG_ROW_LEN PCT_FREE PCT_USED
———- ———– ———– ———- ———-
4789 100 3691 10 40
Which methods can you use to improve the performance? (Choose all that apply.)
A.
online table redefinition
B.
export and import the table
C.
decrease the PCTFREE value
D.
move the table using the ALTER TABLE command