RE: Data stored by fragments.

You can do this by creating a fragmented (partitioned) table. And if you want to get rid of one of the fragments you can just detach that fragment from the main table. When detaching a fragment you ultimately create another table with the same schema as the source table. If you need more info you can refer to the Informix SQL Syntax Guide (topic: ALTER FRAGMENT...DETACH). -----Original Message----- From: Srinivas Sreekumar [mailto:SRINIVAS_SK@infy.com] Sent: Monday, November 13, 2000 7:02 AM To: informix-list@iiug.org Subject: Data stored by fragments. Importance: High Hi Informix gurus, One of my developers has a requirement as below : We need to implement following requirement for our application, " TO SPEED UP THE PURGE PROCESS, IT IS SUGGESTED THAT DATA BE STORED BY FRAGMENTS AND THESE ARE TO BE DROPPED WHEN NOT REQUIRED. " Can anyone is the list enlighten me on how to implement this ie, How to store data in fragments and dropping the same fragments later on. thanks in advance, Srini