User Tools

Site Tools


podoc:files_version_idx_sql_index

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

podoc:files_version_idx_sql_index [2007/10/19 15:37] (current)
Luud created
Line 1: Line 1:
 +===== Database Index Description of "​files_version_idx"​ =====
 +
 +=== Name ===
 +
 +files_version_idx
 +
 +=== Description ===
 +
 +Index on column '​version of table '​files'​.
 +
 +=== Purpose ===
 +
 +Speedup of table row lookups based on column '​version'​ in table '​files'​.
 +
 +=== Schema ===
 +
 +<code sql>
 +create index files_version_idx on files(version);​
 +</​code>​
 +
 +=== Related tables (fields) ===
 +
 +  * [[files sql table|files(version)]]
 +
 +=== History ===
 +
 +== Used first ==
 +
 +Version 2.34
 +
 +== Used last ==
 +
 +Still in use
 +
 +== Change history ==
 +
 += Version 2.34 =
 +
 +<code sql>
 +create index files_version_idx on files(version);​
 +</​code>​
  
podoc/files_version_idx_sql_index.txt ยท Last modified: 2007/10/19 15:37 by Luud