Show TOC

Switching Access Optimization On/OffLocate this document in the navigation structure

Use

If a query returns incorrect results and the suspected cause is an incomplete reference list, then a query report can be generated without access optimization.

See Access Optimization in Queries.

Prerequisites

You are in the Query: Title, Format screen in the Start of the navigation path SAP Query Next navigation step Queries End of the navigation path component.

Procedure

To test a query with access optimization, proceed as follows:

  1. Choose the function Start of the navigation path Extras Next navigation step Additional Special Attributes End of the navigation path.

    The Additional Special Attributes window is opened.

  2. Mark the No Access Optimization checkbox and click Continue .

  3. Use the Test function to test the query.

    Access optimization can be reactivated either by calling up the Start of the navigation path Extras Next navigation step Additional Special Attributes End of the navigation path function again or by deselecting the check box.

    Note

    The access optimization should be deactivated only for test purposes. If the query works correctly when the access optimization is deactivated then the InfoSet must be investigated and corrected so that a complete reference list gets generated (see Access Optimization in Queries). If the query does not work correctly even with the access optimization deactivated then the problem is caused by something else.

    Following a test without access optimization and any necessary processing of the InfoSet, you should always switch access optimization on again. If you do not do this you will see a considerable drop in performance.