From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The query optimizer
From the course: Database Foundations: Database Management
The query optimizer
- [Instructor] The process of querying your tables and retrieving information from the database is almost certainly the most common activity that your system is going to perform. Optimizing query performance is a critical component of developing a database, and it all starts with understanding how queries are actually executed. Query optimization becomes critically important as the size of your database grows and as the number of simultaneous users that it supports increases. If you can shave half a second off the time that it takes a frequently accessed query to return results, then it's worth the effort to find those gains. Half a second might not seem like much but multiply that out times a million requests in a day and it quickly adds up to a significant savings in time, resources, and ultimately money. One technique for speeding up queries is to throw more hardware at the problem. Upgrading to faster memory or hard disks, splitting data tables and indexes across additional drives…
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.