table extents in what chunks?
Posted in 2000
Hi!
In my efforts to "eliminate extent interleaving" I came about to study
the distribution of table extents among dbspace chunks. For a specific
table I want to know in what chunks it's extents are located. (I can do
a "oncheck -pe | more" and look through the output but I want to query
the SMI-tables instead). Any ideas about such a sql-query?
What I then want to do is a "ALTER INDEX TO CLUSTER" on a table
(described in INFORMIX-Online Dynamic Server, Administrator's Guide,
Volume 1 Version 7.1", page 15-23) to rebuild the table with _one_
extent only. My focus on chunks is because of the following lines in
the Guide: "The chunk must contain adequate contiguos space in which to
rebuild the table". But what if the table has extents in many chunks?
Does anybody have experience in doing such a rebuild of a table?
Sent via Deja.com http://www.deja.com/
Before you buy.