From the course: Relational Databases Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Establish table indexes
From the course: Relational Databases Essential Training
Establish table indexes
- [Instructor] When it comes time for your database to retrieve the information that you've painstakingly stored, it'll be often helpful for the most commonly searched fields to contain something called indexes. Indexes are a way for the database to keep track of what records have already been added into your table and to quickly retrieve a record or a group of records when they're requested. To get a feel for how indexes work, let's think about how a phone book is structured. Phone books typically provide a listing of people and their telephone numbers and are indexed by the last name of the individual person. If I were to give you a name to find, say, Evelyn Taylor, it would be very easy for you to jump to the correct page in the T section and find her telephone number. You can do this because the last names are ordered alphabetically which makes it easy for you to quickly find the right name and its corresponding…
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.