Re: Clustered indexes - again

} >So given these responses I am confused. Does leaving an index } >clustered effect future inserts/updates etc? } } >Robert Clark } } } > } >-------------------------------------------------------------- } >e-mail: robert@clark.netkonect.co.uk } >snail: 12 Balvernie Grove, Wandsworth, LONDON, SW18 5RU, UK. } >-------------------------------------------------------------- } Informix does not maintane clustering after the index build. } Therefore, a normal insert or update is treated the same } as it would for any other index. About the only reason } to use a clustered index on a high update table in informix } is to alter index to cluster to regain space without unloading } and reloading the table. } } -- } Tolly Brumbelow, Informix DBA } email:tolly.brumbelow@bridge.bellsouth.com I stand(sit) corrected. My apologies. Anybody got some extra disclaimers? -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 Why does the name Pavlov ring a bell?