Trace ST05 Explaination needed

[Former Member]

Hi All ,

Please help to analyse the below details from ST05 , EXPLAIN option :

This is for KBED table select statement.

SELECT STATEMENT ( Estimated Costs = 1 , Estimated #Rows = 1 )

3 INLIST ITERATOR

2 TABLE ACCESS BY INDEX ROWID KBED

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

Estim. CPU-Costs = 5,563 Estim. IO-Costs = 1

Filter Predicates

1 INDEX RANGE SCAN KBED~0

Search Columns: 3

Estim. CPU-Costs = 1,624 Estim. IO-Costs = 0

Access Predicates

Thanks in Advance

[Former Member]

Hi Harsh,

Please have a look on below help

http://help.sap.com/saphelp_erp60_sp/helpdata/EN/d1/801ff1454211d189710000e8322d00/content.htm

http://help.sap.com/saphelp_erp60_sp/helpdata/EN/d1/801f7c454211d189710000e8322d00/frameset.htm

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[Former Member]

Hello

Estimated Costs = 1

It is the best performance for this query. Than this importance less - so much the better. And less 1 it can not be