If we added a filter, shouldn't the select query run faster?

[yalcin_mete]

Hi Master,

When I run it with only the production plant(werks), the select query runs in a shorter time than when I run it with the production location and material.
How is this possible? Shouldn't the select query run faster when I add material?

Thanks.

[Tomas_Buryanek]

Try ST05 and "Explain" (https://community.sap.com/t5/application-development-blog-posts/the-sql-trace-st05-quick-and-easy/ba...). Select Execution plan is most likely confused. You have quite many joins, conditions etc. so it might behave strange. Also check indexes.

[yalcin_mete · Accepted solution]

I solved the problem.
This problem occurred because I used "SELECT DISTINCT" and "GROUP BY" together.
The problem was solved when I removed "DISTINCT" and continued with "GROUP BY".

SELECT DISTINCT and GROUP BY do almost the same job, so let's not use them both in the same "select" 🙂

[yalcin_mete]

I solved the problem.
This problem occurred because I used "SELECT DISTINCT" and "GROUP BY" together.
The problem was solved when I removed "DISTINCT" and continued with "GROUP BY".

SELECT DISTINCT and GROUP BY do almost the same job, so let's not use them both in the same "select" 🙂

[thomas_mller13]

Only, if there is an index on these fields. Otherwise a full table scan is done.