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:advanced:joins [2012/02/15 21:28] doc |
admin:indexing:advanced:joins [2012/02/16 20:17] doc |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| [[admin:indexing:advanced:subqueries|Subqueries]] | | [[admin:indexing:advanced:subqueries|Subqueries]] | | ||
| [[admin:indexing:advanced:distinct|Distinct]] | | [[admin:indexing:advanced:distinct|Distinct]] | | ||
| + | [[admin:indexing:advanced:aggregations|Aggregations]] | | ||
| [[admin:indexing:advanced:ordering|Ordering]] | [[admin:indexing:advanced:ordering|Ordering]] | ||
| Line 17: | Line 18: | ||
| ==== Joins ==== | ==== Joins ==== | ||
| + | |||
| + | Table joins can add time to a query using any database system. | ||
| + | |||
| + | === Pre-joined Indexes === | ||
| + | |||
| + | |||
| * Prejoined indexes | * Prejoined indexes | ||