This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:home [2012/01/19 22:26] doc |
admin:indexing:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ====== Administration ====== | ====== Administration ====== | ||
| - | ===== Omnidex Indexing ===== | + | ===== Introduction to Omnidex Indexing ===== |
| - | The Omnidex indexing technology is built upon four building blocks that provide the foundation of the product. It is valuable to understand these building blocks before learning how to index your data and tune your application. | ||
| - | === Indexing Concepts === | + | **[[admin:indexing:home|Concepts]]** | |
| + | [[admin:indexing:overview:indexes|Options]] | | ||
| + | [[admin:indexing:overview:creation|Creation]] | | ||
| + | [[admin:indexing:overview:strategies|Strategies]] | | ||
| + | [[admin:indexing:overview:activecounts|ActiveCounts]] | | ||
| + | [[admin:indexing:overview:powersearch|PowerSearch]] | | ||
| + | [[admin:indexing:overview:autocomplete|AutoComplete]] | | ||
| + | [[admin:indexing:overview:text|Text]] | | ||
| + | [[admin:indexing:overview:advanced|Advanced Strategies]] | ||
| - | [[admin:indexing:concepts:home | More >]] | + | ---- |
| - | === Indexing Options === | + | === Indexing Concepts === |
| - | [[admin:indexing:indexes:home | More >]] | + | 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. |
| - | === Index Creation === | + | 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. |
| - | [[admin:indexing:creation:home | More >]] | + | That being said, indexing is not the answer to every problem. There are times to use indexes and times to avoid them. |
| - | === Indexing Strategies === | + | |< 80% 50% 50% >| |
| + | ^ Use Omnidex indexes for ... ^ Avoid Omnidex indexes for ... ^ | ||
| + | | isolating a small number of rows | retrieving a large number of rows | | ||
| + | | processing complex searches | single-use databases | | ||
| + | | using more flexible search options | | | ||
| + | | obtaining counts and aggregations | | | ||
| + | | joining multiple tables | | | ||
| + | | ordering a query result | | | ||
| - | [[admin:indexing:strategies:home | More >]] | + | \\ |
| - | === ActiveCounts === | + | 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:activecounts:home | More >]] | + | [[admin:indexing:concepts:home | More >]] |
| - | + | ||
| - | === PowerSearch === | + | |
| - | + | ||
| - | [[admin:indexing:powersearch:home | More >]] | + | |
| - | + | ||
| - | === AutoComplete === | + | |
| - | + | ||
| - | [[admin:indexing:autocomplete:home | More >]] | + | |
| - | + | ||
| - | === Advanced Strategies === | + | |
| - | + | ||
| - | [[admin:indexing:advanced:home | More >]] | + | |
| - | + | ||
| - | === Application Strategies === | + | |
| - | [[admin:indexing:application:home | More >]] | + | ===== ===== |
| + | ---- | ||
| + | \\ | ||
| + | **[[admin:indexing:overview:indexes|Next]]** | ||
| ====== 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}} | ||