Skip to Content
0
Former Member
Jun 30, 2006 at 04:30 PM

Query perfrmance

25 Views

Hello people

I am having serious performance issues when trying to execute a query with the following structure.I am told the

query returns 70000 records and i am displaying it through a portal.

Can any one suggest how do i built aggregates on the basis of the structure below

Filter

-


Fiscal year variant

Free Characteristics

-


Vendorid (user keys in the range of vendor ids ex ven001 to ven999(using variables)

Fiscal year variant(user keys in the range of period ex 10/2001 to 10/2006 (using variables)

material

Rows

-


Country Key

Zip code

Coloums

-


Cost of product sold

Quantity sold

With Regards

Raju