Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <64s2qc$7lh@cssun.mathcs.emory.edu>, Jayakumar George
<JayaG@unitedgas.co.uk> writes
>Hi all,
>
>Environment : Running 7.23 online on Sequent Dynix PTX.
>
>
>Question.
> In one of our programs , we create a temp table and during the
>processing part it is populated for each processing period(dates) and
>deleted after each processing period.
>
>Over a period of time selecting on the temp table becomes very slow.
>
>Is this normal?.
>or
>should we use update statistics on the temp table ?
>
>NB : The temp table does not have an index and has 3 fields with one
>field as date
> and will have not more than 200 rec / processing period.
>
>Jay
>
Have you done
CREATE TEMP TABLE .... WITH NO LOG
^^^^^^^^^^^
|||||||||||
or
SELECT...INTO TEMP...WITH NO LOG
^^^^^^^^^^^
|||||||||||
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.