Copyright © tutorialspoint.com

SQL - Database Tunning

previous next


It takes time to become a Database Expert or an expert Database Administrator. This all comes with lot of experience in various database designs and good trainings.

But the following list may be helpful for the beginners to have a nice database performance:

Built-In Tuning Tools:

Oracle has many tools for manaing SQL statement performance but among them two are very popular. These two tools are:

  1. Explain plan: tool identifies the access path that will be taken when the SQL statement is executed.

  2. tkprof: measures the performance by time elapsed during each phase of SQL statement processing.

If you want to simply measure the elapsed time of a query in Oracle, you can use the SQL*Plus command SET TIMING ON.

Check your RDBMS documentation for more detail on the above mentioned tools and defragmenting the database.


previous next

Copyright © tutorialspoint.com