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

View index statistics

From the course: Database Foundations: Data Structures

Start my 1-month free trial

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,…

Contents