From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,400 courses taught by industry experts.
Introduction to indexes - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Introduction to indexes
- [Instructor] Imagine you have a vast library with thousands of the books. You want to find a specific book; for instance, "The Great Gatsby". Now, think of the library catalog as an index. Without the catalog, you might have to go through each shelf, check each book title, and waste a lot of time until you find the one which you want. If the library has an organized catalog, that the list of the books, along with the titles and the shelf numbers, it will make your lookup quite easy, because you can just reference that index and you can grab the book from a specific shelf. Or maybe take in another example, think of a restaurant menu. Without having any categories, now, it would be hard to find the dish which you're looking for. An index acts like a categorized menu, making it easy for the waiter to quickly locate and serve the dish you ordered. In SQL, an index do the exactly the same purpose. An index in database…
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.
