I think the best approach is to work with them and state what you are trying
to accomplish - need to run this report, but the performance is not up to
snuff. Then ask them how we could improve it. Ask them for their expertise
and input. You are then treating them as a professional, an expert in their
area and they will probably have a whole different attitude. Yes, Sybrand
is correct. I can think of two ways - a view or a global temporary table.
I suspect the problem lies in how the data is getting retrieved and some
analysis would come up with a better solution.
Jim
"Radu Lascae" <r.nospam.lascae_at_wanadoo.nl> wrote in message
news:fOew8.176$r7.11119_at_castor.casema.net...
> With due respect: why?
>
> I'm not a DBA. I can think of several scenario's in BIS applications where
> I'd improve performance of certain repports by creating tables on the fly.
> Some of these reports can't even be created in straight SQL.
>
> Am I bound to outrage the DBA's with whom I'm working?
>
> Regards,
> Radu
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:uc21ba11ld1076_at_corp.supernews.com...
> >
> [...]
> > Creating tables on the fly however must be considered very bad practice.
> >
> > Regards
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
>
>
Received on Sat Apr 20 2002 - 10:10:57 CDT
