From the course: Advanced SQL for Application Development
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Indexes and bulk data loading
From the course: Advanced SQL for Application Development
Indexes and bulk data loading
- [Instructor] Now we're going to shift gears and talk a little bit about some issues you might run into, in production. The first one I want to talk about, is bulk loading and indexing. Now, when we add data to a table, the data is actually inserted into the table and then, any indexes are updated. So, as we add a row to the table, we add an entry to the index. You can imagine the sequence, add a row to the table, add an entry to the index. Now, that kind of back and forth operation works well, when you're doing transaction processing, so you might have many different processes running to the database, because you have, for example, different customers placing different orders at different times. So this kind of back and forth and writing to the table and the index, in the same kind of operation, it makes a lot of sense. Now, when you're bulk loading data, for example, if you're loading up a bunch of data, maybe…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
Overview of index types2m 26s
-
Using B-tree indexes and range scans2m 6s
-
Using hash indexes and equality operations1m 32s
-
Covering indexes2m 23s
-
Indexes and bulk data loading2m 18s
-
Avoiding index locks3m 3s
-
Challenge: Define a B-tree and a hash index37s
-
Solution: Defining B-tree and hash indexes57s
-
-
-
-
-
-