The Left-Prefix Index Rule

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.