Re: Creating databases and tables in

I strongly discourage anyone from putting 'user' objects (i.e. databases, tables, indexes etc.) in the rootdbs. The rootdbs is a 'critical' dbspace wrt to recovery. Also the logical and/or physical logs are often located there (if you haven't moved them). So, best avoid it for user stuff. Denham.M@amstr.com wrote: > Thought i'd start a discussion of this subject. Anyone out there > got any strong views either way? > > My own view is that creating the dbs in the rootdbs is a bad idea > since this then becomes the default location for all tables created > for the database, and can lead to the rootdbs becoming clogged.... > > For the same reason I would generally frown on creating tables in > this space deliberately. > > Does anyone know if there are any performance benefits from doing > it one way or the other? -- ------------------------------------------------------------ Chris Jenkins, Advanced Technology Group, Informix Software Standard disclaimers apply