Examples for single-partition database environments
Examples for partitioned database environments
This section presents a series of examples, accompanied by illustrations, to show how the access plan and related windows for the basic query change when you perform various tuning activities. They show how the estimated total cost for the access plan of even a simple query can be improved by using the runstats command and adding appropriate indexes.
As you gain experience with Visual Explain, you will discover other ways to tune queries.
Click on one of the following items to view the examples:
You can also follow along interactively using the sample snapshots provided.
| Note: | The access plan graphs illustrated in the examples and the values under the current column may not match those for the sample snapshots, depending on your environment setup and the values in the database you use. |