HomePostsProjects

Index column ordering can be read either way by databases

06-03-2025

  • https://use-the-index-luke.com/sql/sorting-grouping/order-by-asc-desc-nulls-last
  • https://explainextended.com/2009/04/27/descending-indexes/
  • the database uses the index tree to find the last matching entry
  • it the follows the leaf node chain “upwards” (which is why the database uses a doubly linked list to build the leaf node chain)

© 2025 Luke Miloszewski

Email AddressGitHubTwitter