Optimization of keys in tables

amankakar · 2006-10-06

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 · 2006-10-06

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 · 2006-10-06

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.

Optimization of keys in tables

Comments

Categories