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/03/18 15:51] deb |
admin:indexing:concepts:retrieval [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 2: | Line 2: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Administration: Indexing Strategies ====== | + | ====== 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. |