Table Partitioning

Is it possible to partition/fragment a table while keeping it in a single tablespace.

If you have version 10.00 or later, yes. You just have to include the PARTITION <partition_name> clause for each partition and they can all be in the same dbspace. Before 10.00, and if the PARTITION <partition_name> clause is left off, each partition is named after the dbspace you place it in, so they partitions would have to be indifferent dbspaces. By naming the partitions yourself you can do what you want to do. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Aug 9, 2012 at 1:43 PM, GURPREET SACHDEVA <gusachde@cisco.com>wrote: > Is it possible to partition/fragment a table while keeping it in a single > tablespace. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f234ce919c36304c6d9162f