Re: initial extent is LESS THAN first extent size :WHY??

On Thu, 30 Apr 1998 02:45:32 +0100, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <6i8hks$i23$1@news.xmission.com>, ssoman@omm.com writes >> 3. When I create the indexes on this table ( which takes up more than 2.5 >>times the data space ), will that be treated the same way as the data pages ? > Yes, the index and data pages are stored in the same extent i.e. all > mixed in together unless you fragment the index differently to the > data or create a unique index. Yes, but as he create the indexes after the table is loaded I assume all the initial index information will be located "after" the data. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)