Adding covering indexes for aggregate function

It is always recommended to use aggregate function (like sum, avg, minof, maxof and count) in queries where applicable in Axapta. If you run this kind of query frequently, it is considerable to add a covering index for the query. A covering index is an index, which includes all of the columns referenced in the query.
And what is the reason? Because SQL Server can use these entries in the index’s leaf level to perform aggregate calculations. This means that the index contains the data you are looking for, and SQL Server does not have to go to the actual table to perform the aggregate calculations, which can boost performance.
Advertisements
This entry was posted in Axapta Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s