Originally posted by jm
I have a queston for method #2.
I've been told TUNING rule: avoid multi-table join... keep table join to be 2 maximum.
if you want display all "description" for a employy how many table joins?
does it really hurt the performance?
Wow, maybe for {insert your favorite db to trash here}, but not Oracle. Besides, in this case, you would have to join back to the code table each time you wanted to dereference a code value.