Client Specified

[Former Member]

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

[Former Member]

No. It does not.

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

[ssimsekler]

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]

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

[Former Member]

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

[Former Member]

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