User Tools

Site Tools


podoc:support_type_idx_sql_index

Differences

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

Link to this comparison view

Last revisionBoth sides next revision
podoc:support_type_idx_sql_index [2007/04/12 14:23] – created Luudpodoc:support_type_idx_sql_index [2007/04/17 15:20] Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Index on column 'type' of table 'support'.
  
 === Purpose === === Purpose ===
 +
 +Speedup of table row lookups based on column 'type' in table 'support'.
  
 === Schema === === Schema ===
  
-  create index support_type_idx  on support(type);+<code> 
 +create index support_type_idx on support(type); 
 +</code>
  
 === Related tables (fields) === === Related tables (fields) ===
  
   * [[support sql table|support(type)]]   * [[support sql table|support(type)]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related views === 
  
 === History === === History ===
Line 37: Line 37:
 = Version 2.5 = = Version 2.5 =
  
-  create index support_type_idx  on support(type);+<code> 
 +create index support_type_idx on support(type); 
 +</code>
  
podoc/support_type_idx_sql_index.txt · Last modified: 2007/04/23 15:00 by Luud