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.
You are in the Query: Title, Format screen in the component.
To test a query with access optimization, proceed as follows:
Choose the function.
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 thefunction again or by deselecting the check box.
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.