Hi,

> If I have a table in my DB which contains 60 fields, and I have
> created 40 index' (20 asc and 20 desc).
>
> Will this affect the speed of an insert ?

Yes - but most probably not noticable.

Then again - why do you need 40 indices? Do you query with
WHERE clauses on all 20 fields?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."