Indexes
The Importance of Managing Indexes
22/06/10 13:54
We all know that database indexes
help speed up queries against the data, by keeping track of where
records are by certain fields. For instance, fields that get
queried a lot should be indexed to help with performance, and
fields that often have the same data in them are good to index, so
that they can be sorted and grouped together.
There is another important reason to create indexes. In the web client, data grids without indexes sometimes reorder themselves in strange and incomprehensible ways. This can be very disconcerting, to say the least. Add a few indexes on the fields that seem most logical and the data will start behaving itself. It will remain in the exact same order each time it gets queried and refreshed.
So if you’re seeing any strange happenings with your data grids, reviewing your indexes is a great first step in troubleshooting. It might be as simple as adding a few indexes. And the bonus is that your performance should also increase as well.
There is another important reason to create indexes. In the web client, data grids without indexes sometimes reorder themselves in strange and incomprehensible ways. This can be very disconcerting, to say the least. Add a few indexes on the fields that seem most logical and the data will start behaving itself. It will remain in the exact same order each time it gets queried and refreshed.
So if you’re seeing any strange happenings with your data grids, reviewing your indexes is a great first step in troubleshooting. It might be as simple as adding a few indexes. And the bonus is that your performance should also increase as well.