510-022 Exam Dumps | When running optdlag, a table shows a very low data page cluster ratio. Which of the following may improve

<< Prev Question Next Question >>

When running optdlag, a table shows a very low data page cluster ratio. Which of the following may improve the cluster ratio? (Choose three)

A. On a DOL table run reorg rebuild

B. On a DOL table run update statistics

C. On a DOL table recreate clustered index

D. Run update statistics on an Allpage locaked

E. On an Allpage locked table recreate clustered index.

Download PDF File