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
admin:indexing:concepts:aggregations [2012/01/20 18:05]
doc
admin:indexing:concepts:aggregations [2016/06/28 22:38] (current)
Line 3: Line 3:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
  
-====== Administration:​ Indexing ​Strategies ​======+====== Administration: ​Omnidex ​Indexing ======
  
 ===== Indexing Concepts ===== ===== Indexing Concepts =====
Line 26: Line 26:
 The following query requests a simple count from a table.  ​ The following query requests a simple count from a table.  ​
  
-<​code ​sql>+<​code>​
  
   select ​       count(*)   select ​       count(*)
Line 42: Line 42:
 Queries that aggregate data often use GROUP BY clauses or other aggregation functions. ​ These queries can be optimized with Omnidex indexing as well.  The following query shows counts from the HOUSEHOLDS table aggregated by STATE, CITY and ZIP. Queries that aggregate data often use GROUP BY clauses or other aggregation functions. ​ These queries can be optimized with Omnidex indexing as well.  The following query shows counts from the HOUSEHOLDS table aggregated by STATE, CITY and ZIP.
  
-<​code ​sql>+<​code>​
  
   select ​       STATE, CITY, ZIP, count(*)   select ​       STATE, CITY, ZIP, count(*)
Line 55: Line 55:
 These techniques can be used even after other indexes have been used to process criteria. ​ After the criteria has been processed, the isolated record pointers can be used as a filter when the aggregation index is scanned. ​ This allows for great flexibility,​ since the columns referenced in criteria do not need to be included in the aggregation index. ​ In the following query, the same aggregations are restricted to people in the United States.  ​ These techniques can be used even after other indexes have been used to process criteria. ​ After the criteria has been processed, the isolated record pointers can be used as a filter when the aggregation index is scanned. ​ This allows for great flexibility,​ since the columns referenced in criteria do not need to be included in the aggregation index. ​ In the following query, the same aggregations are restricted to people in the United States.  ​
  
-<​code ​sql>+<​code>​
  
   select ​       STATE, CITY, ZIP, count(*)   select ​       STATE, CITY, ZIP, count(*)
 
Back to top
admin/indexing/concepts/aggregations.1327082719.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)