Difference between revisions of "SQL Indexing"
From Suhrid.net Wiki
Jump to navigationJump to search (Created page with "These are notes that I took about SQL Indexing from http://use-the-index-luke.com = Introduction =") |
|||
| Line 2: | Line 2: | ||
= Introduction = | = Introduction = | ||
| + | |||
| + | * An index makes a SQL query fast. | ||
| + | * An index is a distinct structure in the DB that requires its own space. | ||
| + | * A DB index is similar to index of a book - key concept is all entries are arranged in a well-defined order. Finding data in an ordered set is fast and easy because the sort order determines each entries position. | ||
Revision as of 03:58, 2 October 2014
These are notes that I took about SQL Indexing from http://use-the-index-luke.com
Introduction
- An index makes a SQL query fast.
- An index is a distinct structure in the DB that requires its own space.
- A DB index is similar to index of a book - key concept is all entries are arranged in a well-defined order. Finding data in an ordered set is fast and easy because the sort order determines each entries position.
