Keys

Sandra

In one of our tables we have 27 active keys. Since the table (I am speaking of table no. 32) is extreme slow I asked our NSC if I should combine keys differently and reduce the number of active keys. The answer was NO, I could keep all indexes active they were not responsible for slowing the table. I thought too many keys slowed the system. Does anyone know what the correct answer is. Do to many keys slow the system or not.

Thanks all for your help.

Sandra <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />

rmotzer

The time to insert a record will increase if you have also a lot of keys to insert. And it will increase more if the keys contain sum index fields or if they contain a lot of fields. Inserting a record is definitly slower, if you have lot of active keys in your table to maintain.

On the other hand the access to the table is much faster if you use the appropriate key. Especially when you have a huge number of records to handle. And i suppose you have a lot of records in table 32. If you really need the 27 keys - that depends very much on your application. No way to tell that from remote.