Page History
...
You can identify a performance problem by doing one or more of the following:
| Anchor | ||||
|---|---|---|---|---|
|
Simulating an index change is a two-step process.
...
In the Association area on the right, you can see the two statements that will be affected. The Oracle Optimizer is used to compare the cost of the original execution plan with the cost of the new execution plan. In our example, the cost will be reduced and the Change Ratio is less than 100 for both cases. The execution time of these statements and the resources they consume should therefore be reduced.
| Anchor | ||||
|---|---|---|---|---|
|
To simulate removing an index, you first need to add a proposed index change to the table in the Main area.
...