Oracle Database 10g SQL > High Performance SQL Tuning - Pg. 529: Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle Database 10g SQL

Oracle Database 10g SQL

Search

Contents

Table of Contents

About the Author

Acknowledgments

Ch. 1. Introduction

Ch. 2. Retrieving Information from Database Tables

Ch. 3. Using Simple Functions

Ch. 4. Storing and Processing Dates and Times

Ch. 5. Using SQL*Plus

Ch. 6. Subqueries

Ch. 7. Advanced Queries

Ch. 8. Changing Table Contents

Ch. 9. Database Security

Ch. 10. Creating Tables, Sequences, Indexes, and Views

Ch. 11. Introducing PL/SQL Programming

Ch. 12. Database Objects

Ch. 13. Collections

Ch. 14. Large Objects

Ch. 15. Running SQL Using Java

Ch. 16. High Performance SQL Tuning

Introducing SQL Tuning

Use a WHERE Clause to Filter Rows

Use Table Joins Rather than Multiple Queries

Use Fully Qualified Column References When Performing Joins

Use CASE Expressions Rather than Multiple Queries

Add Indexes to Tables

Use WHERE Rather than HAVING

Use UNION ALL Rather than UNION

Use EXISTS Rather than IN

Use EXISTS Rather than DISTINCT

Use Bind Variables

Comparing the Cost of Performing Queries

Passing Hints to the Optimizer

Additional Tuning Tools

Oracle Data Types

URL

Help

CHAPTER 16 High Performance SQL Tuning