Basic SQL tuning tools Conclusion

The purpose of this module was to provide you with skills and strategies to create and normalize SQL procedures for all parties involved in database management.
DBAs who communicate with developers and developers about SQL procedures create much more effective and efficient systems.
We have covered some very important material in the chapter. The concepts include:

Identifying the roles of the DBA in SQL tuning

Enforcing SQL standards

Working with SQL developers

Using SQL in stored procedures

The next module will introduce you to tuning with the EXPLAIN PLAN utility.

Implementing Methods

To implement a method, create the PL/SQL code and specify it within a CREATE TYPE BODY statement.
For example, consider the following definition of an object type named rational_type: