What is meant by a slow index?
Like in a book, SQL has indexes that make data retrieving theoretically faster. However, when a database is not implemented correctly a slower than expected output is achieved through in index. A contributing factor to a slow index can happen with many leaf nodes; when a database contains, for example, multiple entries of the same type, a query is not necessarily done when what the user was looking for is "found" because the rest of the database would need to be traversed; this happens because there is still a potential for the next leaf node to contain the desired result.
No comments:
Post a Comment