cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SQLScript Calculation View Performance Analysis.

former_member435389
Participant
0 Kudos

Hi Expert ,

How to find the SQL statement which cost the most time of SAP SQLScript Calculation View ?

Tks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Jörg_Brandeis
Contributor
0 Kudos

Hi Wei,

you could analyze the execution plan of your scripted View with PlanViz.

Regards,

Jörg

Cocquerel
Active Contributor
0 Kudos

Hello,

You can run a SELECT on your view into a script that looks like this.

do ( )
Begin
SELECT * FROM <YOUR_SCRIPTED_VIEW>;
select * from M_ACTIVE_PROCEDURES
where procedure_connection_id = current_connection;
end;