Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Trace ST05 Explaination needed

Former Member
0 Kudos
78

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
39

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

2 REPLIES 2

former_member387317
Active Contributor
0 Kudos
39

Former Member
0 Kudos
40

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