This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
admin:indexing:strategies:home [2012/02/24 19:56] doc |
admin:indexing:strategies:home [2012/02/24 19:56] doc |
||
---|---|---|---|
Line 16: | Line 16: | ||
==== Overview ==== | ==== Overview ==== | ||
- | |||
- | /* This is a comment */ | ||
The basic strategy for improving query performance is to index all of the columns that are used in criteria, table joins, aggregations and ordering. This is a different approach than is taken with relational databases. Database administrators are usually trained to identify selected columns that are most frequently used and create indexes only on those columns. Their general expectation is that the relational database will choose an index to access a table and will process the rest of the statement by directly evaluating the data. | The basic strategy for improving query performance is to index all of the columns that are used in criteria, table joins, aggregations and ordering. This is a different approach than is taken with relational databases. Database administrators are usually trained to identify selected columns that are most frequently used and create indexes only on those columns. Their general expectation is that the relational database will choose an index to access a table and will process the rest of the statement by directly evaluating the data. |