Optimizing SQL Queries in Oracle
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
What you'll learn
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster, such as transforming your data to normal form, using more efficient SQL code, and using indexes, as well as how to work with partitions.
Table of contents
- Introduction 1m
- Module Contents 2m
- Neaten Up SQL Code 1m
- Restrict Columns/Rows 2m
- INTERSECT vs. INNER JOIN 2m
- MINUS vs. JOIN 2m
- Correlated Subqueries 1m
- IN vs. EXISTS 2m
- Multi-Column IN vs. ANDs/ORs 2m
- The WITH Clause 2m
- The APPEND Hint 2m
- ON Clause vs. WHERE Clause 1m
- Order of Tables on FROM Clause 1m
- Cartesian Products 1m
- Summary 2m
- Introduction 0m
- Module Contents 0m
- What is a List Partition? 2m
- Creating a List Partition 1m
- Examples of List Partitions 2m
- Adding to a List Partition 5m
- Dropping a List Partition 2m
- What is a Range Partition? 2m
- Creating a Range Partition 1m
- Examples of Range Partitions 3m
- Adding to a Range Partition 4m
- Dropping a Range Partition 2m
- Summary 1m
About the author
Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, sheepsqueezers.com, features documents and presentations on a variety of topics he has learned over the years. Scott is also the author of "Android from A to D," which is his take on how a newbie should be taught Android programming, as well as "Poor Man's Data Dictionary," which describes how to quickl... more