Performance problems with the AUSP table.

[former_member317781]

hi masters,

in my prog am using the AUSP SELECT like this.

SELECT SINGLE * FROM ausp WHERE objek EQ ausp_objek AND

atinn EQ cabn-atinn.

and when used the TRACE I see that this select statement duration is 350.930 which is in RED color.

how can i improve this select pls?

thank you,

jacob.

[Former Member]

this is probably not your problem,

+Repeat several times, before you execute the trace.

+Summarize the trace (trace - summarize by SQL statements), what is your total DB time and what are the most expensive statements?

[Former Member]

Hi Jacob,

Check if you can also add KLART to your query so it will use an better index (N3?) My experience is that the KLART field normally is a cosntant depending on the scope of your requirement.

Maybe also look at your trace which index it is using.

Kind regards,

Robert

[Former Member]

Hi Jacob,

generally AUSP table is not taking time to execute query. plz check your trace again.

although you can add KLART andATZHL for filteration criteria and make index for this four field

( objek, atinn,atzhl and klart ). after that execute again..It will be not taking time to execute query.

Regards,

Kunjan

[fidel_fernandez]

Hello,

I have the same problem. How do you solve it?

Thanks!

Fidel.

[Former Member]

we also have severe performance problems with this table although all relevant index are available

I think it's just a matter of size of the table. We have no idea how to improve on accelearte the search with Transaction cv04n.