Week 5 learning journal CST 363
The web site "Use the Index Luke" has a page on "slow indexes". https://use-the-index-luke.com/sql/anatomy/slow-indexes Links to an external site. If indexes are supposed to speed up performance of query, what does the author mean by a slow index? Even though the database is using an index, the query can still take a long time to run, making it a "slow index". If the database has to look through a lot of matching entries in the index then get each row from the table it can take extra time because slows down the performance . The process of following all the matches and getting the data can make it slower than expected.