Simulation of SELECT statements

[Former Member]

Hi,

Can anybody help on developing a SELCT-TOOL program with following conditions:

This new program should be able to pass any SELECT statement to the database and evaluate certain KPIs like response time, number of records selected, index used u2026u2026

The program should not be able to display selected records.

The program should be able to simulate working in foreground as well as in background.

The program should be able to generate a result list which could be printed on our laser printer.

The program should not be executable for everybody but for selected users only.

Reason for this request is that we often face issues in Prod with programs having select statements which are neither optimized nor sufficiently tested. Hence we need to find a way to simulate all select statements of any coding on Prod before actually transporting them.

I used ST05 transaction, but it is not sufficient to test all kinds of SELECT statments.

It is restricted to very limited SQL statements.

Thanks,

Rama

[Former Member]

Hi,

Can anybody help on developing a SELCT-TOOL program with following conditions:

This new program should be able to pass any SELECT statement to the database and evaluate certain KPIs like response time, number of records selected, index used u2026u2026

The program should not be able to display selected records.

The program should be able to simulate working in foreground as well as in background.

The program should be able to generate a result list which could be printed on our laser printer.

The program should not be executable for everybody but for selected users only.

Reason for this request is that we often face issues in Prod with programs having select statements which are neither optimized nor sufficiently tested. Hence we need to find a way to simulate all select statements of any coding on Prod before actually transporting them.

I used ST05 transaction, but it is not sufficient to test all kinds of SELECT statments.

It is restricted to very limited SQL statements.

Thanks,

Rama

[Former Member]

Hi,

u can use ST05...(SQL Trace)

There u can enter an Select statement...and check its performance...

ST05-->Enter SQL Statement

rest u can understand....

[Former Member]

Hi,

I did same thing already as i mentioned in my request.

I have used ST05 transaction --> Enter SQL statement.

It works if SQL statement is too simple.

But in real time we give little bit complex SELECT statements.

we use Internal Tables, some times Joins too....

I need solution for medium/complex SELECT statements.

Any help?

Thanx,

Rama