|
1878.5.4
by Brian Aker
Update documentation. |
1 |
Indexes
|
2 |
=======
|
|
3 |
||
4 |
To quote wikipedia, "An index is a data structure that improves the |
|
5 |
speed of data retrieval operations on a database table at the cost of slower |
|
6 |
writes and increased storage space. Indexes can be created using one or more |
|
7 |
columns of a database table, providing the basis for both rapid random |
|
8 |
lookups and efficient access of ordered records. The disk space required to |
|
9 |
store the index is typically less than that required by the table (since |
|
10 |
indexes usually contain only the key-fields according to which the table is |
|
11 |
to be arranged, and exclude all the other details in the table), yielding |
|
12 |
the possibility to store indexes in memory for a table whose data is too |
|
13 |
large to store in memory." |
|
14 |
||
15 |
||
16 |
.. toctree:: |
|
17 |
:maxdepth: 2
|
|
18 |
||
19 |
create_index |
|
20 |
drop_index |