Tuesday, February 7, 2023

Databases: Journal 5

 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