Re: [Fwd: Correct Answer]

Hi, Below is the excerpt from INFORMIX Dynamic Server Administration: When you create an explicit temporary table using the IN dbspace option of CREATE TEMP TABLE, OnLine stores the temporary table in that dbspace. When you do not use the IN dbspace option of CREATE TEMP TABLE, or when you create the explicit table with SELECT... INTO TEMP, OnLine checks the DBSPACETEMP environment variable and the DBSPACETEMP configuration parameter. (The environment variable supersedes the configuration parameter.) When DBSPACETEMP is set, OnLine stores the explicit temporary table in one of the dbspaces specified in the list. OnLine keeps track of the last dbspace in the list that it used to store a temporary table. When OnLine receives another request for temporary storage space, it uses the next dbspace in the list. In this way, OnLine spreads I/O evenly across the temporary storage space that you specify in DBSPACETEMP. When you do not specify any temporary dbspaces in DBSPACETEMP, or the temporary dbspaces that you specify have insufficient space, OnLine creates the table in a standard (nontemporary) dbspace according to the following rules: n If you created the temporary table with CREATE TEMP TABLE, OnLine stores this table in the dbspace that contains the database to which the table belongs. n If you created the temporary table with the INTO TEMP option of the SELECT statement, OnLine stores this table in the root dbspace.Implicit Temporary Tables OnLine stores implicit temporary tables in one of the dbspaces that you specify in the DBSPACETEMP environment variable or the DBSPACETEMP configuration parameter. (The environment variable supersedes the configu-ration parameter.) When DBSPACETEMP is not set, OnLine stores the temporary table in the root dbspace. When OnLine creates implicit temporary tables in the process of sorting, it checks the PSORT_DBTEMP environment variable in addition to checking the DBSPACETEMP environment variable and the DBSPACETEMP configuration parameter. For further information on this topic, see the INFORMIX-OnLine Dynamic Server Performance Guide. Regards Carl Guse wrote in message <6f1mv4$gl4$1@news.xmission.com>... > >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? > >