To use temp_tables or not

[Daniel Sanchez <dsanchez@WYNDHAM.COM>]

Hi, all.

I do personally use temp tables as workbench tables (complex calcs and all
that fun stuff), but rather than dropping them, I truncate them, in case I
need them in the future. This was done by recommendation of our DBAs
(tablespace and DB fragmentation).

Now that I've mentioned the fragmentation issue, one of our DBAs also
suggested to create another user with all kinds of rights using another
schema or tablespace (DBA talk... it's either of these 2) so that it does
not defrag the DB. Check with your DBA, if this affects you in any way.

HTH. Thanks,


Daniel A. Sanchez

-----Original Message-----
From:   Craig Gaudon [mailto:cgaudon@KILCOM1.UCIS.DAL.CA]
<mailto:[mailto:cgaudon@KILCOM1.UCIS.DAL.CA]>
Sent:   Monday, February 05, 2001 10:15 AM
To:     SQR-USERS@list.iex.net <mailto:SQR-USERS@list.iex.net>
Subject:        To use temp_tables or not


Hi,
I have a question. Is it better to create your SQR's by creating temporary
tables,
populating those tables with info from permanent tables, selecting from
those
tables for the report, and dropping the temporary tables, or is it better to
not use
temporary tables at all and just select from the permanent tables for the
report?
Being new to SQR and coming from Oracle Reports I just don't see the logic
in
using temporary tables.

Craig Gaudon
craig.gaudon@dal.ca <mailto:craig.gaudon@dal.ca>