Ansicht
Dokumentation

13008 - Cost Based Optimizer for DB2/400

13008 - Cost Based Optimizer for DB2/400

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Cost Based Optimizer for DB2/400

What would you consider as high 1000, 10000 or????



Best regards

Klaus



-----Oprindelig meddelelse-----
Fra: Satid Singkorapoom [mailto:satidZt...]
Sendt: 24. februar 2004 08:54
Til: DoNotReply@consolut.eu
Emne: Re: Cost Based Optimizer for DB2/400



Using ST04 --> Detail Analysis Menu --> Index Advice, try to see if there
are very high counts on "Index Advice Count" column (after sorting this
column in descending order). If so, drill down to see the SQL
statement with the highest index advice count and start creating
indexes as advised in the detailed information (the bottommost
information field) to see if there is any run-time improvement. It will be=


good if U can recognise whether the table name with the highest index
advice count is related to any particular query that appears to have run-
time performance issue.

Satid S.
IBM Thailand

--- In DoNotReply@consolut.eu, sumanjit_chowdhuryZi...
wrote:
> Hi Group,
> We are on Kernel patch 1604 and at the Latest PTF level, in SM50
> almost all the programs are seen as performing Sequential Reads
which is
> affecting performance very badly i want to know how does the
Optimizer
> works for DB2/400 if it also uses CBO then it should also access the
Table
> Access Statistics , i want to know how to check whether table access
> statistics are getting generated or not is there any job scheduled to
> update the statistics ..etc..
>
>
> Any help on this...
>
> Thnks nd Regds,
>
> Sumanjit
>
>
>
>
>
> __
> IMPORTANT NOTICE:
> This email may be confidential, may be legally privileged, and is for
the intended recipient only.
> Unauthorised access, disclosure, copying, distribution, or reliance on
any of it by anyone else is prohibited and may be a criminal offence.
> Please delete if obtained in error and email confirmation to the
sender.



Have a look to our homepage at: http://www.consolut.net
<http://www.consolut.net>
DoNotReply@consolut.eu




_____

consolut Links

* To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/
<http://groups.consolut.net/group/SAP on System i/>


* To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu
<mailto:DoNotReply@consolut.eu?subject=Unsubscribe>


* Your use of consolut is subject to the consolut Terms of
<http://www.consolut.net> Service.



[Non-text portions of this message have been removed]


Durban Tours - Südafrika Safari

TXBHW - Original Tax Base Amount in Local Currency   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 4265 Date: 20240328 Time: 145655     sap01-206 ( 3 ms )