What’s Next?
The next chapter will discuss techniques and tools that can be used to increase the performance of your SQL statements. The chapter will discuss the various indexes that can be used and will also discuss EXPLAIN, which is used to learn what work an SQL statement must perform. Finally, the chapter will discuss when to use a full table scan rather than an index lookup and how to optimize joins, grouping, and sorting operations.
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
