Re: Having too many indexes on a table

In article <1998050303392200.XAA12710@ladder03.news.aol.com>#1/1, kponn@aol.com (KPonn) wrote: > > >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. > I am just speculating, but I do know that in SE, the entire index is stored in just one file. This would tend to disperse the pages belonging to a particular index, which could slow performance (especially if any read-ahead is being done--it would become a waste instead of a benefit). John Prideaux alastl@ctnet.net -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading