Using indexes effectively requires understanding how they work. This means deciding which columns to index, which data types to use, and whether to use IHASH. You also need to know how to improve performance when using a text index.
When adding an index to a column, consider the following criteria:
•Columns that are neither primary nor foreign keys, but are frequently referred to in queries and sorts
•Columns that have rules applied to them
•Linking columns in views
•The index is more efficient if each row contains a value
•The index is more efficient based on the uniqueness of the data
When properly implemented, indexes can greatly improve the data retrieval performance of your applications!
