Home/ Questions/Q 352460
Next
In Process
Naseer Lanka
Asked: 2022-11-05T07:50:10+05:30 In:

To maintain performance of tables having variable length rows, which statement is used?

(a) MAINTAIN TABLE

(b) BALANCE TABLE

(c) ADJUST TABLE

(d) OPTIMIZE TABLE

To maintain performance of tables having variable length rows, which statement is used?

(a) MAINTAIN TABLE

(b) BALANCE TABLE

(c) ADJUST TABLE

(d) OPTIMIZE TABLE
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. The correct option is (d) OPTIMIZE TABLE

    Best explanation: In the variable length rows, there is more fragmentation of the table on which many deletes or updates are performed. OPTIMIZE TABLE is run periodically to maintain performance.

    • 0