cancel
Showing results for 
Search instead for 
Did you mean: 

Query Performance

Former Member
0 Kudos
206

Hi ,

Query is taking a very long time to execute.With my ID it gets executed within secs.But through Test USer it takes approximately around 45mins.I tried using RSDDSTAT table,I tried debugging through RSRT , even tried through ST05.But I'm not able to find what can be the problem.According to me it should be some authorization proble..Please let me know how to use ST05 trace .I got the trace & somewhere on fetch it is highlighted.then what next .How can i corretc the error.

Regards,

Anita

View Entire Topic
Former Member
0 Kudos

Hi All,

Details of RSDDSTAT Table.

QTIMEOLAPINIT is 2,593750

QTIMEDB is 16,140625

TIMEAUTHCHECK is 2.057,968750

In St05 it takes a long time to fetch UST10s table.

I dont know how to resolve this issue.

Thanks

Regards,

Anita

GFV
Active Contributor
0 Kudos

Hi Anita

effectivelly the biggest time is spent during authority check. In ST05 check the SQL Explain for the select statement in table UST01S: may be statistics are not updated? In OSS I saw there are some notes about this table ...

What about Authorization Objects? Are you using Custom ones? Could you be more specific about the checks you are performing with this Query?

Hope it helps

GFV

Former Member
0 Kudos

Hi ,

I am using some customised authorization objects.Test user is having authorization to view only some specific

cost center.

For all the cubes stastics is up to date .

Thanks & Regards,

Anita

GFV
Active Contributor
0 Kudos

Hi Anita,

you say "some customized authorization objects" ... how many?

Are you using author obj based on hierarchies? I saw some notes about (e.g. 838615 Performance optimization with hierarchy). Are they suitable to your problem?

Are you using some variables withcustomer exits?

Hope it helps

GFV

Former Member
0 Kudos

Hi GFV,

Thanks for your Quick response.Now I have compressedd all the cubes & I have created the Stastics & Indexes again .

Now its taking hardly 2mins for the Execution.Even the note seems to be helpfull in my case .

Thanks a lot Gianfranco .

Thanks & Regards,

Anita