on 12-09-2014 8:38 AM
Hi all,
When I check the same sql statement in different systems, P system and Q system.
It shows different execution plan for inner join
Sql statement
Excution plan
For system P the value of MANDT is 1 table EKPO accessed first with full table scan.
For system Q the value of MANDT is 4 table EKKO accessed first with index EKKO~1(in P also has this index)
Data volume in Q is a little bit larger than P.
Could you please help to find out why there is such a difference? which one is correct?
How the optimizer works when process the inner join for maxDB?
Thanks & Regards,
Chris
Hello Chris,
Check if the statistics are up to date on these tables - Perform and UPDATE STATISTICS for the tables and then compare the execution plan.
More information see SAP Note - 1368477 - FAQ: SAP MaxDB Queryrewrite
Regards,
Yashwanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.