on ‎2008 Oct 23 7:06 AM
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
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
Hi
Please do also post the sql statement as well, executions, buffer gets, number of rows would help as well.
Regards Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.