ST04-SQL Request

[Former Member]

Hi Friends,

In my production system, I've executed the ST04 transaction, Detailed Analysis Menu....SQL Request....Sorted by Buffer gets... and I checked the SQL statement....and then clicked on display execution plan for SQL statement...

There it shows the following information

SELECT STATEMENT ( Estimated Costs = 17,039 , Estimated #Rows = 0 )

1 TABLE ACCESS FULL LIPS

( Estim. Costs = 17,038 , Estim. #Rows = 1 )

Estim. CPU-Costs = 885,646,245 Estim. IO-Costs = 16,963

Filter Predicates

What are the parameters that will indicate that there is an issue with the SQL statement

Regards

Aliila

[pavan_kumargali]

Hi Aliila,

As informed by Dileep, 'TABLE ACCESS FULL LIPS' is one of the indicator for expensive SQL. And again it depends on the size of the table. If the size is less then some times Full table scan would be better for the statement.

I want to include one more expensive SQL indicator "Estimated Costs = 17,039". Generally Estimated Costs should be in single or double digits, which means SQL statement is performing well.

If you want more information, please let me know.

Thanks and Regards,

Pavan Kumar Gali.