User Tools

Site Tools


podoc:photo_tech_photo_idx_sql_index

Differences

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

Link to this comparison view

Next revision
Previous revision
podoc:photo_tech_photo_idx_sql_index [2007/04/12 14:21] – created Luudpodoc:photo_tech_photo_idx_sql_index [2007/04/23 14:57] (current) Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Index on column 'photo' of table 'photo_tech'.
  
 === Purpose === === Purpose ===
  
-=== Schema ===+Speedup of table row lookups based on column 'photo' in table 'photo_tech'.
  
-  create index photo_tech_photo_idx           on photo_tech(photo);+<code sql> 
 +create index photo_tech_photo_idx on photo_tech(photo); 
 +</code>
  
 === Related tables (fields) === === Related tables (fields) ===
  
   * [[photo_tech sql table|photo_tech(photo)]]   * [[photo_tech sql table|photo_tech(photo)]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related views === 
  
 === History === === History ===
Line 37: Line 35:
 = Version 2.5 = = Version 2.5 =
  
-  create index photo_tech_photo_idx           on photo_tech(photo);+<code sql> 
 +create index photo_tech_photo_idx on photo_tech(photo); 
 +</code>
  
podoc/photo_tech_photo_idx_sql_index.1176387679.txt.gz · Last modified: 2007/04/12 14:21 by Luud