Optimizing SQL Queries in Oracle

This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
Course info
Rating
(211)
Level
Intermediate
Updated
Apr 15, 2014
Duration
3h 46m
Table of contents
Optimizing SQL Queries in Oracle
Basic SQL Optimization Part I
Basic SQL Optimization Part II
Overview of Indexes
B-Tree Indexes
Bitmap Indexes
Additional Index Types
Overview of Partitions
Simple Partitions
Composite Partitions
Partition/Index Interaction
Description
Course info
Rating
(211)
Level
Intermediate
Updated
Apr 15, 2014
Duration
3h 46m
Description

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.

About the author
About the author

Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!

More from the author
SQL Data Wrangling in Oracle: Table Data
Intermediate
5h 18m
Nov 27, 2014
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
Jan 14, 2014
More courses by Scott Hecht
Section Introduction Transcripts
Section Introduction Transcripts

Optimizing SQL Queries in Oracle
Hello and welcome to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this course I'll be discussing several things you can do to speed up your SQL queries. We'll cover everything from rearranging your table data, to modifying your SQL code, as well as how to use indexes and partitions. Let's get started.

Basic SQL Optimization Part I
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module we'll take a look at some basic methods to optimize your SQL queries with changes applied only to your data. The information presented in this module usually should be performed first before moving on to the other optimization techniques we talk about later on in the course, so let's get started.

Basic SQL Optimization Part II
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht. Recall that in the last module we discussed changes to your data and saw how much quicker SQL queries can execute when those changes were made to a large table. In this module we'll take a look at a few basic methods to optimize your SQL queries themselves with changes to just the SQL code. As I mentioned before, the information presented in this module, as well as the last one, should be performed first before moving on to the more advanced optimization techniques, such as indexes and partitions, both of which we talk about later on in the course. Let's get started.

Overview of Indexes
Hello and welcome back to the Pluralsight course Optimizing SQL Queries in Oracle. My name is Scott Hecht. In the previous two modules we tried to speed up our SQL queries by transforming our data into Third Normal Form, as well as modifying the SQL code itself, and we did all of this avoiding indexes and partitions. Now, that's about to change. In this module we do an overview of the type of indexes available to the SQL programmer and how they work. In the following modules we go into more detail about everything introduced in this module so, let's get started.

B-Tree Indexes
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to go over the B-Tree index in a little more detail than what was presented in the overview module, so let's get started.

Bitmap Indexes
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to go over the Bitmap Index in a little more detail than what was presented in the overview module, so let's get started.

Additional Index Types
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to go over several additional index types in a little more detail than what was presented in the overview module. Specifically, we'll talk about Function-Based Indexes, Bitmap Join Indexes, and finally, Index-Organized Tables so, let's get started.

Overview of Partitions
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to present an overview of Oracle partitions, so let's get started.

Simple Partitions
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to take an in-depth look into the list and range partitions, so let's get started.

Composite Partitions
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and recall from the last module that we talked about basic partitions and how they can speed up your queries using Partition Pruning. In this module I'd like to talk about composite partitions or partitions within partitions, so let's get started.

Partition/Index Interaction
Hello and welcome back to the Pluralsight course, Optimizing SQL Queries in Oracle. My name is Scott Hecht and in this module I'd like to talk about how indexes and partitions interact. That is, how do you create an index on a partition table and how does a change in partition structure affect indexes, so let's get started.