Database Systems - Week 5
It seems as though a slow index could be from multiple reasons. Sometimes a query must actually search through all the rows in a table even using an index because the query is looking for too wide of a search. Reading Slow Indexes in RDBMS at https://use-the-index-luke.com/sql/anatomy/slow-indexes, it talks about the leaf node chain and how even though the database traverses the tree, it also has the follow the leaf node chain completely to make sure there are no missed values. The article also talks about how fetching the table data can also take a lot of time if the data is spread out around different areas of the hard drive. I would think that SSD would have much faster search and read speeds than HDD, so this may be a step forward in speed with using an SSD.
Comments
Post a Comment