Where are tables/indexes created ??

Posted in 1999

Pramod Dhumal — Thu, 18 Feb 1999 03:48:26 PST — source: Informix-list mailing list archive (1991-1998)

Hi List users, Thank U for your previous responses to my queries on moving from DEC 4000 to Alpha 4100. I have 2 queries : 1. In our database some tables are specifically defined as "create table ....in dbspace...." whereas some there is no dbspace mentioned. Since I have 4 dbspaces, I want to know which table is in which dbspace exactly ?? 2. How do I get the size (KB) of all indexes used in my database? Is it possible to create indexes also in specific dbspaces ?? Thanks in advance..... Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com