Which methods can you use to improve the performance?

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