The Left-Prefix Index Rule
Summary
02/05/19 There’s an important heuristic in database indexing that I call the left-prefix rule. It helps you understand whether the database will be able to make the best use of a multi-column index to speed up a query. It’s one of a small handful of ... The post The Left-Prefix Index Rule appeared first on SolarWinds Blog.
Read the Original Article
This article originally appeared on SolarWinds Blog.
Read Full Article on Original Site
