RE: Sizing existing indexes - How to do?

Cosmo - I think you missed the original poster's question, which I believe is: Is there any way to specify extent sizes for the indices of a table, separate from the data/table? Answer No. This has been a feature request of mine, for over a year and half. This becomes even more important, and necessary, now that you have the ability to fragment tables, indices, and create indices detached. Since the indices are treated essentially as tables (as far as storage with DSA), why can't we control the extent sizing?? Are you listening Informix?? Jon ------------------------------ Jon C. Vemo jvemo@cyberspace.com Bothell, WA U.S.A. ---------- From: Cosmo[SMTP:simond@informix.com] Sent: Thursday, December 07, 1995 3:31 AM To: informix-list@rmy.emory.edu Subject: Re: Sizing existing indexes - How to do? Peter Tashkoff wrote: > > Hi all > I am scoping a database in 7.10 on Sol 2.4 for envisaged requirements > in the new year. > oncheck -pe gives me the page usage by table, incuding the indices for > the table.> Does anyone know of any nifty ways to size the indices by > themselves? I have taken a look thru the manuals but can't find anything > of help. Hmmm. Grab those manuals again and lookup oncheck -pT. That will list all the space usage for data and index pages for a tablespace. Cosmo