Re: Help - Clustered Index to Keep the Table in Desired Order

This is a multi-part message in MIME format. --------------308C311F22C5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mickey Mestel wrote: > note that when you build the table with the clustered index, the engine > literally builds a new table, drops the old one, and renames the new one. > this means that you have to have enough room for another table of this size, > plus the space taken up by the index. > > if you don't have the space, you can download the table to tape or > disk, create a new table with the clustered index, reload the table, drop the > old table, and rename the new (essentially what the engine does). And you will wind up with a table that is effectively unclustered. The ONLY way to get a truly clustered index/table is to create a clustered index or alter an existing index to cluster AFTER the table has all the data you want to have in it loaded. There is no way around the double space requirement. -- Dave Kosenko, Informix Professional Services **************************************************************************** While it is true that there is more than one way to skin a cat, the cat himself generally fails to appreciate the differences. --------------308C311F22C5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="IFXDISCL.TXT" ************************************************************************* Note: please do not send me email asking about features, or asking about Informix problems and how to solve them. I answer what questions I can in this forum (comp.databases.informix) when I have the time to spare. For questions on features, call your local sales rep or check out the Informix web site (http://www.informix.com). For technical problems, call Informix tech support. ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------308C311F22C5--