DB queries are usually sped up when paired with an index - however, indexes can become corrupt and require reindexing.