podoc:album_content_album_idx_sql_index
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
podoc:album_content_album_idx_sql_index [2007/04/12 14:15] – created Luud | podoc:album_content_album_idx_sql_index [2007/04/23 14:52] (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 album_content_album_idx on album_content(album); | ||
+ | </ | ||
=== Related tables (fields) === | === Related tables (fields) === | ||
* [[album_content sql table|album_content(album)]] | * [[album_content sql table|album_content(album)]] | ||
- | |||
- | === Related indexes === | ||
- | |||
- | === Related functions === | ||
- | |||
- | === Related views === | ||
=== History === | === History === | ||
Line 37: | Line 37: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
+ | create index album_content_album_idx on album_content(album); | ||
+ | </ | ||
podoc/album_content_album_idx_sql_index.txt · Last modified: 2007/04/23 14:52 by Luud