Description of the illustration ixadvisorsheetopthints.gif

This figure shows the Index Advisor Configuration dialog. The dialog has a drop-down list for the Capture Mode. The selected option for the Capture Mode is Prepare SQL. Below the drop-down list is a check box that enables you to include optimizer hints for an Oracle BI server. The Include optimizer hints in Oracle BI server check box is selected. Below the check box is a field that shows the optimizer hints for the Oracle BI server. At the bottom of the dialog are the Start and Cancel buttons.