From the course: Database Foundations: Data Structures
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
View index statistics
From the course: Database Foundations: Data Structures
View index statistics
- [Instructor] Indexes exist to help speed up query performance, but they come at a cost. Having too many indexes or indexes on the wrong columns can be detrimental to the operation of your database, since they'll negatively impact write performance. Because of this, it's going to be in your best interest to periodically review the indexes created in your database to make sure that they're still beneficial to the system. Finding indexes that are not used very often and removing them from tables with lots of activity is a good first step in index management. The ways that you do this aren't standardized across the various RDBMS platforms though. So the specific techniques and commands will vary. Let's take a look at PostgreSQL first, and then we'll look at some similar commands on SQL server. I'm going to select the two trees database in my PostgreSQL server. And then come up to file and open file. And in the Chapter Six folder,…
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.