How to test the select statement.

[Former Member]

Hi All,

How to test the select statement.

Is there any Oracle sqlplus or toad kind of tool to test the query.

thanks

siva

[Former Member]

Hi,

Please chk the following links

http://www.informit.com/articles/article.aspx?p=664660

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_boj_erq/....do

Regards,

Manish

[Former Member]

Hi,

Write the select statement, and check it in debug mode.

Thanks,

Sriram Ponna.

[Former Member]

Hi Siva,

You can use the debugging option to check the SELECT Statement. To check the contents of the table into which the data was selected, write a STOP after Select and keep a breakpoint on STOP. Remember to remove the STOP statement after checking the contents of the table.

Regards,

Chandra Sekhar

[Former Member]

hi,

The Best way for testing the SELECT statement is to switch the debugger on.

Here you can find all the entries which are extracted by your seelct Query and also the conditions you have applied will be fulfilled or not.

Regards

Sumit Agarwal

[SureshRa]

Use SQL Trace (ST05) and choose 'Explain one SQL Request'. Enter your SQL command as it should be executed in the underlying database. e.g. if the db is Oracle, the statement should be entered as:

SELECT matnr,werks,lvorm,dispo

FROM marc

WHERE mandt = :a AND

matnr = 😛 AND

werks = :c

In the above :a, 😛 and :c are place holders for the actual comparison values. You dont have to enter those values. When you choose 'Explain' button, you will find the 'Execution Plan'. The important parameter which denotes the efficiency of the SQL statement is the 'Cost'. The cost should be as low as possible. The table access should be through INDEX UNIQUE SCAN. If you get a FULL TABLE SCAN and higher cost, you need to fine-tune your statement by modifying the where clause.

If you dont know Oracle SQL statements, execute the program in trace mode and go to the trace and you will find the underlying SQL statements issued to the database.

Regards

Suresh Radhakrishnan

[Former Member]

Hi,

you can check it in the debugging mode.

(or)

you can use se30 tcode.. which will help you to check select stmt performance.

Regards,

venkat