jackal wrote:
> Hi Faculties,
>
> I ve a database which is normalised. But there are lot of tables which
> are created just to hold temporary data. These tables are used mainly
> by PL/SQL procedures and sometimes used directly in the front end
> application for reporting purposes. I ve found that a properly formed
> SQL query would have done the work in almost all the cases, as an
> alternative.
>
> Is it good to use such tables? Do they afftect the database performance
> in any way?
>
> Thanks in advance
> Jackal
It is bad to use such tables, provided they are not global temporary
tables (and even then I'd avoid them most of the time) and they will
negatively affect scalability and performance.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Mar 21 2006 - 11:22:20 CST
