dbTalk Databases Forums  

Tablespace, Diskspace or sql abuse..

comp.databases.oracle.server comp.databases.oracle.server


Discuss Tablespace, Diskspace or sql abuse.. in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Nuno Souto
 
Posts: n/a

Default Re: Tablespace, Diskspace or sql abuse.. - 06-24-2003 , 10:41 PM






nikey11 <member31783 (AT) dbforums (DOT) com> wrote


Quote:
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?

I don't think the issue is professionalism.
It is highly dependent on what the requirements are
in your particular case. If the design of the db
and the requirements for data mandate that such a join
be done, then that's it. Abstracting any wishes for
quick re-development or re-design, which are nothing
but wishful thinking.

Now, of course it may need tuning or refining or whatever
terminology your folks use. In order to make it meet
a certain level of service and performance. A true
professional will accept that as a given, nothing wrong
with it and par for the course.

That's where you should be building the bridges with your
DBA: they can help in that area. Avoid confrontational
situations on other fields: they favour no one in the work place.

Cheers
Nuno Souto
wizofoz2k (AT) yahoo (DOT) com.au.nospam


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.