cst 363: week 5

https://use-the-index-luke.com/sql/anatomy/slow-indexes

Question: If indexes are supposed to speed up performance of query,  what does the author mean by a slow index? 

Answer: A slow index typically happens when looking up data using an index tends to take longer than expected. This can happen if there are too many matching entries, or if it takes a while to fetch table data. For example, if there are lots of rows that match the search query, it can make the lookup a lot slower. Also, at the end of the day, people think that rebuilding an index can fix the issue of slow queries, but it really depends on the database, and how it accesses and retrieves data.