Optimizing SQL Queries in Oracle

—Introduction 0m 40s
—Module Contents 1m 41s
—Neaten Up SQL Code 0m 50s
—Restrict Columns/Rows 1m 43s
—INTERSECT vs. INNER JOIN 1m 47s
—MINUS vs. JOIN 1m 54s
—Correlated Subqueries 1m 11s
—IN vs. EXISTS 1m 36s
—Multi-Column IN vs. ANDs/ORs 2m 17s
—The WITH Clause 1m 51s
—The APPEND Hint 1m 41s
—ON Clause vs. WHERE Clause 1m 14s
—Order of Tables on FROM Clause 1m 17s
—Cartesian Products 1m 0s
—Summary 1m 54s

—Introduction 0m 32s
—Module Contents 1m 13s
—What is an Index? 4m 29s
—B-Tree Indexes 2m 56s
—Bitmap Indexes 3m 22s
—Function-Based Indexes 1m 8s
—Index-Organized Tables 1m 5s
—Bitmap Join Indexes 1m 29s
—Gathering Statistics 2m 3s
—Index/Partition Interaction 1m 40s
—Example 3m 40s
—Summary 1m 19s

—Introduction 0m 15s
—Module Contents 1m 8s
—What is a B-Tree Index? 2m 13s
—When do you use a B-Tree Index? 4m 50s
—Creating a B-Tree Index 5m 5s
—Listing the Indexes on a Table 4m 23s
—Dropping a B-Tree Index 0m 41s
—Gathering Statistics 5m 24s
—Is my Index Being Used? 4m 48s
—Summary 1m 25s

—Introduction 0m 16s
—Module Contents 0m 41s
—What is a Bitmap Index? 2m 51s
—When do you use a Bitmap Index? 2m 14s
—Creating a Bitmap Index 1m 55s
—Dropping a Bitmap Index 0m 33s
—Is my Index Being Used? 2m 57s
—Summary 0m 28s

—Introduction 0m 22s
—Module Contents 0m 22s
—Function-Based Indexes 4m 30s
—Bitmap Join Indexes 7m 37s
—Index-Organized Tables 5m 6s
—Summary 1m 15s

—Introduction 0m 12s
—Module Contents 1m 0s
—What is a Partition? 3m 12s
—Varieties of Partitions 5m 11s
—Partition-Wise Joins 0m 55s
—Partition/Index Interaction 1m 17s
—Examples 3m 13s
—Summary 0m 59s

—Introduction 0m 14s
—Module Contents 0m 29s
—What is a List Partition? 2m 16s
—Creating a List Partition 0m 43s
—Examples of List Partitions 1m 51s
—Adding to a List Partition 4m 33s
—Dropping a List Partition 1m 40s
—What is a Range Partition? 1m 30s
—Creating a Range Partition 1m 27s
—Examples of Range Partitions 2m 39s
—Adding to a Range Partition 3m 50s
—Dropping a Range Partition 1m 31s
—Summary 1m 8s

—Introduction 0m 21s
—Module Contents 1m 4s
—What is a Composite Partition? 1m 54s
—Varieties of Composite Partitions 1m 11s
—Example #1 - List/List 3m 49s
—Example #2 - Range/List 4m 43s
—Example #3 - AUTOTRACE 1m 30s
—Summary 1m 6s

—Introduction 0m 20s
—Module Contents 0m 42s
—Partition/Index Interaction 2m 19s
—Global Non-Partitioned Indexes 2m 26s
—Local Partitioned Indexes 1m 27s
—Changes in Partitions Affect Indexes 2m 32s
—Summary 1m 9s