Re: Multiple temp tables

Posted in 1997

David Williams — Sat, 17 May 1997 10:05:29 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5le44e$dar$1@news13.gte.net>, Paul Drake <pdrake1@gte.net> writes >When I make a temp table using "WITH NO LOG", it appears that multiple >tables are made for that one temp table (multiple entries in systabnames). >Trying it on two different systems, it appears the number of tables it >makes is the same as the number of dbspaces in DBSPACETEMP. This does not >happen with logging (only 1 table made). Has anyone else noticed this? Is >there a reason that this happens? > > > Thanks, > Paul Performance - the table gets fragments across the entries in DBSPACETEMP each entry should be on a different disk thus allowing parallel access and distributing the load across several disks. -- David Williams