topic Re: Trace ST05 Explaination needed in Application Development and Automation Discussions

Trace ST05 Explaination needed

Former Member — Fri, 06 Nov 2009 04:36:20 GMT

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 — Fri, 06 Nov 2009 05:44:02 GMT

Hi Harsh,

Please have a look on below help

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Former Member — Fri, 06 Nov 2009 06:01:30 GMT

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