Select two correct statements from below concerning the ANALYZE command.

Question

Options

• AIt renews the statistical information of the table content.
• BIt takes some time to execute, but it does not lock the table.
• CIf the FULL option is used when executing, the size of the file can be reduced.
• DIf ANALYZE isinsufficient, the most efficient search plan will not be selected for queries.
• EIf ANALYZE is not used atall, there are times when it becomes impossible to see any of the

• A
  78% (50)
• B
  3% (2)
• C
  5% (3)
• E
  14% (9)

No community discussion yet for this question.