Tablespace, Diskspace or sql abuse..

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 24 Jun 2003 17:17:12 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703D3DF67@lnewton.leeds.lfs.co.uk>

As with may things Oracle, it depends !!

It depends on what the query is actually trying to do, also on whether the database was properly designed and normalised (or denormalised as appropriate !),
and probably lots of other things that I can't quite remember at the moment !

On the other hand, if said query is performing a cartesian join to itself (three times) then this is probably not a good thing.

HTH Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----

From: nikey11 [mailto:nikey11]On Behalf Of nikey11 Posted At: Tuesday, June 24, 2003 4:00 PM Posted To: server
Conversation: Tablespace, Diskspace or sql abuse.. Subject: Re: Tablespace, Diskspace or sql abuse..

First of all, I'd like to say 10x to Arcangelo, Norm And Nuno. your swift replies have been most helpfull in confronting my evil dba... I've proven to him that he was wrong by his assumption that my query is not logical by running it on a smaller table.

My question for you now is this:
Have I been unproffesional by creating a query that combines a table of 1358453 rows 3 times to itself?
should I considered a different approach?

All the best to you,
noam.

--

Posted via http://dbforums.com Received on Tue Jun 24 2003 - 11:17:12 CDT