How to increase performanceof query based on Infoset?

[Former Member]

How to increase the performance of a query based on a Infoset?

As per designing of query, all the necessary fields are placed where they are required.

[Former Member]

Hi Akshara ,

• To improve performanceof query try to remove unnecessary characteristics, attributes, or key figures ,Superfluous conditions or variables .Large InfoCubes and Complex hierarchies .Variables populated by user exits

• For characteristics specify either variables or restrictions .

• You can create indexes on DSO and Aggregates on cubes (if any).

Please go through the links :

http://help.sap.com/saphelp_crm40/helpdata/en/77/4a213cc534f20ae10000000a11402f/content.htm

Hope you will find this helpful.

Regards,

Jaya

[Former Member]

The links donot apply to this case.

The first link deals with having Business partner in DSO which isn't with my case.