Re: foreign key: auto-index creation?

dbTools package includes Index Analyzer PRO utility that can search for foreign keys that should have an index build for them. Note that the tool automatically analyzes many parameters of indexed and non-indexed tables and generates suggestions based on table size, index cardinality, data selectivity and distribution, and many other things. For example, it can suggest that an index is not needed for a "small" lookup table if a full table scan is more efficient that accessing the index.

Check it out at http://www.softtreetech.com/monitor/

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jul 24 2000 - 00:00:00 CDT