I am the only user in our entire production environment that has access to run transaction SQVI. I don't use it daily but it is an analysis tool I use from time to time to dump data. My Basis group is reluctant to allow continued use of this transaction because if an "improper" join is created it could impact system performance. I disagree and here's why.
1. We are running ECC 6.0 and whenever I create a join between tables SAP knows which fields to join on and does it automatically. If I try to force a join on incompatible fields it disallows it and I get a system error.
2. SQVI queries are subject to time constraints just like any other transaction or report and will abend based on run time limitations.
Considering there are not 100's of users pounding the system on a daily basis with SQVI queries or joins my minimal usage has negligable impact on system performance.
I appreciate any and all comments related to this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.