A017 goes via KAPOL and gives me a performance issue.
I have a query (I need to figure out werks based on a price condition ) :
select single werks from a017
where kappl = 'M'
and kschl = 'PB00'
and knumh = change_document_header-objectid.
The problem with this query is that it makes a full table scan. About 300 000 records.
I don't have any more data to add to my query.
A017 is a pooled table.
When I run this query in ST05 I can see that the query access a table name KAPOL which is a Table pool.
So... the select is on A017 and is accessed via KAPOL.
Any Pointers ?