2 weeks ago
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.
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" 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
11 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.