Re: Tables created to hold temporay data. Good or Bad?

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

See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6407993912330 and search for "Never do procedurally that which can be done in a single sql statement."

jg

--
@home.com is bogus.
"Not a significant regulatory action."
http://www.signonsandiego.com/uniontrib/20060321/news_1n21taxes.html