Related to Optimization

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Selet only the required fields and not *.

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

Regards,

Srini.

[Former Member]

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

[Former Member]

Hi,

Check this link

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

Regards,

Srini.

[Former Member]

Hi,

Ashok,

No, Im not using Joins..

Srini,

How can we create Secondary on standard table?

Thanks

[Former Member]

If you are using join, try to fix that

Regards

Ashok Advani