Hi Markus,
I don't have an answer to your question, but would like to discuss in detail to see if it leads to some conclusion.
As far as I know, there is no way to view the log of the entire process chain (other than SLG1). You can see the log of...
>> how come same TR works in Quality and not in Production
Quality and production systems are usually not 100% identical. Another transport may have taken an object to Q and that may not have gone to P.
Display the inactive object in P and perfor...
Ken,
objnr+0(2) IN ('PR','NV')
Above syntax is disallowed (at least when Oracle is the database). If that is allowed in your installation, it should be easy to write a test program and check for yourself. You can use GET TIME STAMP statement to m...
When you say "millions of records" do you mean in the tables or in the results? If the SELECT statement is fetching millions of rows, it will certainly take a lot of time no matter which method you use.
A join itself cannot be bad for performanc...
