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:home [2012/01/20 17:36]
doc
admin:indexing:home [2016/06/28 22:38] (current)
Line 5: Line 5:
 ====== Administration ====== ====== Administration ======
  
-===== Omnidex Indexing ===== +===== Introduction to Omnidex Indexing =====
- +
-Omnidex provides a wide variety of indexing capabilities. ​ The simplest applications may simply require a few indexes to be added, but other applications may use many more indexing capabilities. ​ It is useful to get a quick overview of the indexing capabilities of Omnidex. ​ Customers commonly purchase Omnidex for its basic indexing capabilities,​ only to discover there is more more available.+
  
  
Line 18: Line 16:
 [[admin:​indexing:​overview:​autocomplete|AutoComplete]] | [[admin:​indexing:​overview:​autocomplete|AutoComplete]] |
 [[admin:​indexing:​overview:​text|Text]] | [[admin:​indexing:​overview:​text|Text]] |
-[[admin:​indexing:​overview:​advanced|Advanced]] ​| +[[admin:​indexing:​overview:​advanced|Advanced ​Strategies]] 
-[[admin:​indexing:​overview:​applications|Applications]]+
 ---- ----
-\\ 
  
 === Indexing Concepts === === Indexing Concepts ===
 +
 +Omnidex provides a wide variety of indexing capabilities. ​ The simplest applications may simply require a few indexes to be added, but other applications may use many more indexing capabilities. ​ It is useful to get a quick overview of the indexing capabilities of Omnidex. ​ Customers commonly purchase Omnidex for its basic indexing capabilities,​ only to discover there is more more available.
  
 Omnidex takes a completely different approach to indexing that other databases. ​ Instead of adding a single index here and there, administrators are encouraged to index all of the columns used in criteria, table joins, aggregations,​ ordering, and in certain circumstances,​ even retrievals. ​ Using this approach, most queries will be fulfilled through the indexes without having to access the database at all.  ​ Omnidex takes a completely different approach to indexing that other databases. ​ Instead of adding a single index here and there, administrators are encouraged to index all of the columns used in criteria, table joins, aggregations,​ ordering, and in certain circumstances,​ even retrievals. ​ Using this approach, most queries will be fulfilled through the indexes without having to access the database at all.  ​
Line 30: Line 29:
  
 |< 80% 50% 50% >| |< 80% 50% 50% >|
-^ Use indexes for ...                  ^ Avoid indexes for ...             ​^+^ Use Omnidex ​indexes for ...          ^ Avoid Omnidex ​indexes for ...     ​^
 | isolating a small number of rows     | retrieving a large number of rows |  | isolating a small number of rows     | retrieving a large number of rows | 
 | processing complex searches ​         | single-use databases ​             | | processing complex searches ​         | single-use databases ​             |
Line 38: Line 37:
 | ordering a query result ​             |                                   | | ordering a query result ​             |                                   |
  
 +\\
 +
 +it is useful to understand how Omnidex uses indexes to optimize each of these situations. ​ This knowledge will help in choosing the best selection of Omnidex indexes and options. ​
  
 [[admin:​indexing:​concepts:​home | More >]] [[admin:​indexing:​concepts:​home | More >]]
Line 49: Line 51:
 ====== Additional Resources ====== ====== Additional Resources ======
 See also: See also:
-{{page>:​admin:​basics:​see_also&​nofooter&​noeditbtn}}+{{page>:​admin:​indexing:​see_also&​nofooter&​noeditbtn}}
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
admin/indexing/home.1327080966.txt.gz · Last modified: 2016/06/28 22:38 (external edit)