Switching Access Optimization On/Off

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:

Choose the function Extras Additional Special Attributes.

The Additional Special Attributes window is opened.
Mark the No Access Optimization checkbox and click Continue .
Use the Test function to test the query.

Access optimization can be reactivated either by calling up the Extras Additional Special Attributes 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.