This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:creation:home [2012/03/02 20:20] doc |
admin:indexing:creation:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| [[admin:indexing:creation:performance|Performance]] | [[admin:indexing:creation:performance|Performance]] | ||
| ---- | ---- | ||
| - | === Overview === | + | ==== Overview ==== |
| Most relational databases, such as Oracle, SQL Server and MySQL, encourage administrators to create a few carefully-chosen indexes on a table. These indexes are created using the CREATE INDEX statement, which sequentially scans the table and populates the index. A table with three or four indexes will require three or four CREATE INDEX statements, each of which will sequentially scan the table and populate the index. | Most relational databases, such as Oracle, SQL Server and MySQL, encourage administrators to create a few carefully-chosen indexes on a table. These indexes are created using the CREATE INDEX statement, which sequentially scans the table and populates the index. A table with three or four indexes will require three or four CREATE INDEX statements, each of which will sequentially scan the table and populate the index. | ||