Re: Create Index Problem.....

Posted in 1998

Birdman — Mon, 23 Mar 1998 22:24:08 +0800 — source: Informix-list mailing list archive (1991-1998)

Hi, Abhay Mannur wrote in message <6euris$cpp$1@news.xmission.com>... > >Hi, > >sysextents table in sysmaster database reports it But if I create >the same index without 'in dbspace' clause, it doesn't report it. Yes, the extents mixed with data and index, that is to say, the tablespace is made up by data and index pages, with other type pages like bitmap, blob pages. No separate 'index extent' exist! >Why ? ? > >Abhay Mannur >Informix DBA >Fairchild Semiconductor