RE: Performance advice

Posted in 2004

Art S. Kagel — Fri, 23 Apr 2004 13:26:23 -0400 — source: Usenet: comp.databases.informix

On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp table activity goes to the database's home dbspace or rootdb. If you list normal dbspaces along with the 'temp' dbspaces in DBSPACETEMP the engine will use them intelligently. Art S. Kagel

Related threads

Different instances with markedly different times