Re: [Fwd: Correct Answer]

Carl Guse wrote: > > X-Mozilla-Status: 0001 > Message-ID: <35145A0C.41F6@inlink.com> > Date: Sat, 21 Mar 1998 18:23:40 -0600 > From: Carl Guse <pivotal@inlink.com> > Organization: Pivotal Development Solutions > X-Mailer: Mozilla 2.01 (WinNT; I) > MIME-Version: 1.0 > To: informix-ist@iiug.org > Subject: Correct Answer > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > I have a bet riding on the correct answer for this > question: > > Can the location of temporary tables be > configured? Yes and no. The environment variable DBSPACETEMP specifies one or more dbspaces into which to place temp tables. Inversions prior to 7.3, though a temp table could be created in any of the listed dbspaces and in general was done by each thread in a round robin fashion such that if your connection created three temp tables and there are two spaces in the list the third table goes in to the same space as the second. Version 7.3 is supposed to be able to create temp tables fragmented across all DBSPACETEMP spaces. So, in the sense that, if set, DBSPACETEMP controls which dbspace(s) are used for temp tables, yes you can control it. However, if more than one dbspace is specified you cannot know which dbspace will contain a particular temp table. Art S. Kagel