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