OPTIMIZE SQL STATEMENTS BASED ON ORACLE8I

摘要

This paper introduces phases for getting high performance applications, then focus on methods of optimizing SQL statements based on Oracle8i that may greatly enhance application performance. Some guidelines for creating indexes are also presented.