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 18:20]
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 37: Line 36:
 | joining multiple tables ​             |                                   | | joining multiple tables ​             |                                   |
 | 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. ​ 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. ​
 
Back to top
admin/indexing/home.1327083615.txt.gz · Last modified: 2016/06/28 22:38 (external edit)