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: 

Indexes

Former Member
0 Kudos

1) How can we check the performance of the created secondary index ?

2) How can we check the performance of the ABAP Program ?

3) What is the Cost Based Optimizer ?

1 ACCEPTED SOLUTION

Sm1tje
Active Contributor
0 Kudos

1/2. In transaction ST05, you can check if index is used. And in SE30 you can check the overall performance.

3. This is database optimizer which will select best index for selections.

The parameter optimizer_mode is set for SAP systems and should only be changed if recommended by SAP. You should also take into account the appropriate notes.

In contrast to the rule-based optimizer, you should create statistical tables for the cost-based optimizer. If you do not regularly create these table statistics, this may cause the cost-based optimizer to make wrong decisions and result in performance problems.

Edited by: Micky Oestreich on May 14, 2008 6:53 AM

5 REPLIES 5

Sm1tje
Active Contributor
0 Kudos

1/2. In transaction ST05, you can check if index is used. And in SE30 you can check the overall performance.

3. This is database optimizer which will select best index for selections.

The parameter optimizer_mode is set for SAP systems and should only be changed if recommended by SAP. You should also take into account the appropriate notes.

In contrast to the rule-based optimizer, you should create statistical tables for the cost-based optimizer. If you do not regularly create these table statistics, this may cause the cost-based optimizer to make wrong decisions and result in performance problems.

Edited by: Micky Oestreich on May 14, 2008 6:53 AM

Former Member
0 Kudos

2--> To check the performence of a ABAP Program

Goto Program on the toolbar in the report screen then navigate as follows program->check> extended program check and code inspector .

These provides the performence trace.

3--->In detail about Optimerzers and Cost based optimizer

The Optimizer

Each database system uses an optimizer whose task is to create the execution plan for SQL statements (for example, to determine whether to use an index or table scan). There are two kinds of optimizers:

Rule based

Rule based optimizers analyze the structure of an SQL statement (mainly the SELECT and WHERE clauses without their values) and the table index or indexes. They then use an algorithm to work out which method to use to execute the statement.

Cost based

Cost based optimizers use the above procedure, but also analyze some of the values in the WHERE clause and the table statistics. The statistics contain low and high values of the fields, or a histogram containing the distribution of data in the table. Since the cost based optimizer uses more information about the table, it usually leads to faster database access. Its disadvantage is that the statistics have to be periodically updated.

Use

ORACLE databases up to and including release 7.1 use a rule-based optimizer. As of Release 7.2 (SAP Release 4.0A), they use a cost-based optimizer. All other database systems use a cost-based optimizer.

Former Member
0 Kudos

I Myself solved the issue.