CST363 Week 5
Use the Index, Luke This title references the website: Use the index, Luke A "slow index" in this case is an index range scan that is looking through a majority of an index, causing it to access tables many times more than what could be necessary. One solution to this problem is to write better `where` clauses for search queries. The author also mentions specific "anti-patterns" to avoid, which include mixing data types (like using numbers exclusively in a string), math in search queries, and using date types incorrectly.