Re: Ex Size

David Williams (djw@smooth1.demon.co.uk) wrote: : In article <6aqt9c$mhd$1@news.xmission.com>, Art S. Kagel : <kagel@ns1.bloomberg.com> writes : >Detached indexes have a hard limit on the number of extents that they can : >have which is CALCULATED from the keysize and NEXT SIZE of the table so : >a larger next size for active tables with detached indexes is critical or : >the detached indexes will eventually run out of extents and become : >DISABLEd. : > : Where is this documented? Isn't it applied to tablespace as well, and not just detached index? This is, however, documented in the ODS Performance Guide on chapter 3-28 "Upper Limit on Extents". Chris -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: paclck@hk.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>