How to find unused indexes

Carmen_S
Carmen_S Member Posts: 19
edited 2008-07-30 in Navision Attain
We have a 3.10 native database running on a 3.7 executable. I would like to know if there is any easy way to determine if there are unused indexes.
Carmen Stanciulescu
Vancouver, Canada

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Developer's toolkit is a good start... It will show you all references to the indexes (Where used) plus flowfields that might (or might not) use them. You also need to investigate your code manually. It's a dirty job... but the results are worth it... :D
  • Tarek_Demiati
    Tarek_Demiati Member Posts: 112
    You may also want to check out the Unused Key tool, available here :

    http://www.mibuso.com/dlinfo.asp?FileID=755
  • Carmen_S
    Carmen_S Member Posts: 19
    Thank you both Kapamarou and Tarek for your suggestions. I will try them and post the result.

    Regards,
    Carmen
    Carmen Stanciulescu
    Vancouver, Canada