From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Indexes and bulk data loading

Indexes and bulk data loading

From the course: Advanced SQL for Application Development

Start my 1-month free trial Buy for my team

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…

Contents