This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:concepts:retrieval [2011/01/24 15:27] 127.0.0.1 external edit |
admin:indexing:concepts:retrieval [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Administration: Indexing Strategies ====== | + | {{page>:top_add&nofooter&noeditbtn}} |
| + | ====== Administration: Omnidex Indexing ====== | ||
| ===== Indexing Concepts ===== | ===== Indexing Concepts ===== | ||
| Line 15: | Line 15: | ||
| ---- | ---- | ||
| - | ==== Retrieval ==== | + | ==== Retrievals ==== |
| As Omnidex optimizes a query, it looks for ways to use indexes to process criteria, table joins, aggregations and ordering. It may also find that the data to be returned to the user can be obtained from the indexes. This can allow an entire query to be processed without ever accessing the database. This technique provides exceptional performance. | As Omnidex optimizes a query, it looks for ways to use indexes to process criteria, table joins, aggregations and ordering. It may also find that the data to be returned to the user can be obtained from the indexes. This can allow an entire query to be processed without ever accessing the database. This technique provides exceptional performance. | ||
| Line 23: | 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 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. | + | 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 ====== | ||