This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
admin:indexing:concepts:retrieval [2011/01/17 22:42] els |
admin:indexing:concepts:retrieval [2012/01/20 18:08] doc |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | + | ~~NOTOC~~ |
| - | ====== Administration: Indexing Strategies ====== | + | {{page>:top_add&nofooter&noeditbtn}} |
| + | ====== Administration: Omnidex Indexing ====== | ||
| ===== Indexing Concepts ===== | ===== Indexing Concepts ===== | ||
| Line 22: | Line 23: | ||
| Other queries may request primary keys, or even data from other columns. If these columns are found in the indexes, they will be returned from the index in order to minimize retrieval from the database. Omnidex will automatically perform this optimization. | Other queries may request primary keys, or even data from other columns. If these columns are found in the indexes, they will be returned from the index in order to minimize retrieval from the database. Omnidex will automatically perform this optimization. | ||
| - | Using these techniques, it is possible to optimize complex queries without ever accessing the database. A query may access a dozen or two tables, applying a wide variety of criteria and performing aggregations and ordering. If Omnidex can, it will attempt to satisfy all of these aspects in the indexes, providing the best performance possible. | + | Using these techniques, it is possible to optimize complex queries without ever accessing the database. A query may access dozens of tables, applying a wide variety of criteria and performing aggregations and ordering. If Omnidex can, it will attempt to satisfy all of these aspects in the indexes, providing the best performance possible. |
| - | + | ||
| - | + | ||
| ===== ===== | ===== ===== | ||
| **[[admin:indexing:concepts:ordering|Prev]]** | **[[admin:indexing:concepts:ordering|Prev]]** | ||
| + | |||
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||