Sunday, July 11, 2010

Which fields are indexed in reporting databases?

We, mainly, create index on date fields in databases (basically tables) which are frequently used in reporting. This is because most of the time reports are created on the date bases. So because we will be fetching data from the tables mostly on the basis of date field creating index on it will reduce the execution time of the query as index on the date field will help in easily sorting of the rows in the table.

No comments:

Post a Comment