Re: Too many indexes

In article <01bd6d21$9d3b4ee0$190210ac@vodachois2040.vodac.co.za>, Dirk Moolman <dirkm@vodac.co.za> writes >I've often heard that too many indexes on a table can slow down >performance. Why is this ? >The only reason I can think of is when you insert or update the table, it >will slow down as it has to update the indexes as well. > Correct. Plus updates have to be logged. Plus locks may need to be taken out on the index. >Bye >Dirk -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care