[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Index usage recorded in index statistics?

Status
Not open for further replies.
C

ChUIMonster

Guest
If the indexes fall within the range and the reads are 0 then, yes, they are unused and candidates for removal. However... keep in mind that some indexes may only be used occasionally. They might, perhaps, only be used for a month-end or even year-end process and thus look like they are unused because your measurement period did not cover those times. You might also want to consider whether or not you have been keeping statistics up to date for the query optimizer. If you have not then it could that they are unused simply because the query optimizer doesn't have data suggesting that they would help.

Continue reading...
 
Status
Not open for further replies.
Top