Re: Clustering and indexes

Posted in 2000

a_blonde@mindless.com — Fri, 26 May 2000 11:53:03 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > Hi... > > 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? > 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? Perhaps a question to ask first is, "is the clustering of a cluster index maintained?". The answer is, "no". So it's not a good idea to cluster volatile tables Dude. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com