Performance Tools

Team-Fly

---

 

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents
	Hour 17.  Improving Database Performance

---

Many relational databases have built-in tools that assist in SQL statement and database performance tuning. For example, Oracle has a tool called EXPLAIN PLAN that shows the user the execution plan of a SQL statement. There is another tool in Oracle that measures the actual elapsed time of a SQL statementTKPROF. In SQL Server, there are numerous SET commands that can be used to measure the performance of the database and SQL statements. Check with your DBA and implementation documentation for more information on tools that may be available to you.

---

Team-Fly

Top