Re: Clustering and indexes

From: trubisz@cs.sunysb.edu (Joe Trubisz) > >Technical informix questions: >1. When you have a CLUSTERED index and do an UPDATE, >does informix perform a 'update in place' of the data >space or does it perform a DELETE/INSERT pair? Update in place -- the index loses its "clusteredness" over time... >2. If you have a table which will have a very high >percentage of INSERTS but MAYBE a worst case of 2% >DELETEs/UPDATEs, is there a penalty associated with having >a CLUSTERED INDEX IFF the data is being INSERTed into >the table in ascending key order all the time? Well, yes, but it might not be significant. It's hard to say. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com