topic Re: Related to Optimization in Application Development and Automation Discussions

Related to Optimization

Former Member — Wed, 24 Mar 2010 09:23:25 GMT

Hi all Professional,

I'm using cluster table in my program. I want to know that, what all are the optimization technique for fast performance with "SELECT" query (apart from WHERE clause).

Thanks

Devinder

Re: Related to Optimization

Former Member — Wed, 24 Mar 2010 09:31:04 GMT

Hi,

Selet only the required fields and not *.

Also avoid using " into CORRESPONDING FIELDS OF TABLE ... "

Regards,

Srini.

Re: Related to Optimization

Former Member — Wed, 24 Mar 2010 09:44:11 GMT

Hi Srini,

I've already used that filelds which is usable.

Secondly, Just do let me know, Can I create Secondary Index on that Particular Cluster Table. If Yes, Then How can I create a Secondary Index.

& Is this much helpful for optimization.

Thanks

Devinder

Re: Related to Optimization

Former Member — Wed, 24 Mar 2010 10:30:31 GMT

If you are using join, try to fix that

Regards

Ashok Advani

Re: Related to Optimization

Former Member — Wed, 24 Mar 2010 10:40:25 GMT

Hi,

Check this link

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

Regards,

Srini.

Re: Related to Optimization

Former Member — Wed, 24 Mar 2010 11:13:20 GMT

Hi,

Ashok,

No, Im not using Joins..

Srini,

How can we create Secondary on standard table?

Thanks