podoc:rating_photo_idx_sql_index
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| podoc:rating_photo_idx_sql_index [2007/04/12 14:21] – created Luud | podoc:rating_photo_idx_sql_index [2007/04/23 14:59] (current) – Luud | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| === Description === | === Description === | ||
| + | |||
| + | Index on column ' | ||
| === Purpose === | === Purpose === | ||
| + | |||
| + | Speedup of table row lookups based on column ' | ||
| === Schema === | === Schema === | ||
| - | | + | <code sql> |
| + | create index rating_photo_idx on rating(photo); | ||
| + | </ | ||
| === Related tables (fields) === | === Related tables (fields) === | ||
| * [[rating sql table|rating(photo)]] | * [[rating sql table|rating(photo)]] | ||
| - | |||
| - | === Related indexes === | ||
| - | |||
| - | === Related functions === | ||
| - | |||
| - | === Related views === | ||
| === History === | === History === | ||
| Line 37: | Line 37: | ||
| = Version 2.5 = | = Version 2.5 = | ||
| - | | + | <code sql> |
| + | create index rating_photo_idx on rating(photo); | ||
| + | </ | ||
podoc/rating_photo_idx_sql_index.1176387711.txt.gz · Last modified: 2007/04/12 14:21 by Luud