Re: Having too many indexes on a table

Posted in 1998

KPonn — 03 May 1998 03:39:22 GMT — source: Informix-list mailing list archive (1991-1998)

>Is it slows down to have too many index. If it slows down for >insertion and delete it is >OK. But is it slows down "select " also? I recently worked on a program (ESQL/C) that was taking about 6 hrs run. One of the table is pretty large and had 17 indexes on it . I removed unnecessary indexes (about 15 of them) and didn't modify the code. Now it runs in 24 minutes.