SAP Knowledge Base Article - Preview

2985430 - SQL optimization and index usage

Symptom

A query has a WHERE clause and therefore, ADS creates automatically an Advantage Optimized Filter (AOF). However, ADS does not use existing indexes for optimizing that AOF.

The warning message is:

Restriction is not fully optimized. 
Unoptimized Part: REFERENCE="1234.12.12"

But there are two indexes, IDX_ALT_REF and primary key, that could be used.


Read more...

Environment

SAP Advantage Database Server 12

Product

SAP Advantage Database Server 11.1 ; SAP Advantage Database Server 12.0

Keywords

KBA , BC-SYB-ADS , ADS (Advantage Database Server) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.