Optimization of keys in tables

amankakar

Hi

Is it possible to know whether keys in all tables are properly used or not,meaning can we eliminate unused keys in tables by using NDT or any other tool.

giulio.cipo

exist a tool that is in beta version the tool name is unused key and you can download at this address:

http://www.mibuso.com/dlinfo.asp?FileID=755

DenSter

You can use the NDT to analyze where keys are used, but you will need to do custom analysis to determine the extent of it. Each implementation is unique, so for each database you will have to do this analysis specifically for that database.