Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Client Specified

Former Member
0 Kudos

Does the use of 'client specified' in open SQL statements improve the performance of SQL statements.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

No. It does not.

In fact, if you use <i>Client Specified</i> and specify clients other than SY-MANDT, the performance may worsen.

5 REPLIES 5

Former Member
0 Kudos

No. It does not.

In fact, if you use <i>Client Specified</i> and specify clients other than SY-MANDT, the performance may worsen.

0 Kudos

Hi

I agree with Anand that it will not do any performance optimization.

However, I am not sure whether it may worsen the performance since it just disables automatic client handling. Anyways, this is in fact not so much in context of the main question, besides the question is answered.

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Former Member
0 Kudos

Hi Raghuram,

You can prove this to yourself.

You can test the performance of statements side by side using the Performance Tips and Tricks transaction. From SE80 go to Environment->Examples->Performance Examples.

Type in your two select statements (one with client specified and one without) in the two windows and hit the measure runtime button. If you have a reasonable amount of data you should be able to tell any difference. Although as Anand says, I don't think you'll see any.

Cheers,

Brad

0 Kudos

Hi Brad,

Thanks for the reply, but what i also wanted to know was which would be better simply giving a delete statement or use a delete with a client = sy-mandt

0 Kudos

I think you should use automatic client handling unless you actually want to delete data in a different client from the current one.

There is no use of specifying client = sy-mandt .

Thanks,

Ram