User Tools

Site Tools


podoc:album_content_album_idx_sql_index

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:album_content_album_idx_sql_index [2007/04/17 14:16]
Luud
podoc:album_content_album_idx_sql_index [2007/04/23 14:52] (current)
Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Index on column 'album' of table 'album_content'.
  
 === Purpose === === Purpose ===
 +
 +Speedup of table row lookups based on column 'album' in table 'album_content'.
  
 === Schema === === Schema ===
  
-  create index album_content_album_idx on album_content(album);+<code sql> 
 +create index album_content_album_idx on album_content(album); 
 +</code>
  
 === Related tables (fields) === === Related tables (fields) ===
Line 31: Line 37:
 = Version 2.5 = = Version 2.5 =
  
-  create index album_content_album_idx on album_content(album);+<code sql> 
 +create index album_content_album_idx on album_content(album); 
 +</code>
  
podoc/album_content_album_idx_sql_index.1176819406.txt.gz · Last modified: 2007/04/17 14:16 by Luud