Re: OT - database and indexes... but anyone please?

Rory Browne wrote: <snip>deleting an index(a good index that > is) would slow the db down in certain cases. Deleting a "bad index" > would speed certain operations up. <snip> If the index in question happens to be a unique index or a primary key (really just a special case of index) - you could be breaking the logic of the table (allowing duplicates where there should be none). Pretty much as Rory (the other one) said: An index makes write operations slower and read operations faster. When you are doing bulk inserts to a table it is often a good idea to drop any index , populate the table and then re-index (for performance reasons). Regards Rory