Description of the illustration sql_access_advisor_mode.gif

This screenshot shows the Scope section on the SQL Access Advisor: Recommended Options page. Text describing the options in the section says: "The advisor can run in one of two modes, Limited or Comprehensive. Limited Mode is meant to return quickly after processing the statements with the highest cost, potentially ignoring statements with a cost below a certain threshold. Comprehensive Mode will perform an exhaustive analysis."

The section has the following options:

• Limited (selected)

  Text associated with the option is, "Analysis will focus on highest cost statements."

• Comprehensive

  Text associated with the option is, "Analysis will be exhaustive."

End of description.