Re: table joins or seperate begin-select clause

[Donald Raikes <draikes@primenet.com>]

At 01:32 PM 9/19/96 -0400, you wrote:
>Which is better for machine performance, to join several tables within a
>single begin-select clause or separate begin-select clauses?
>
>Thanx
>
>Bob
>

Bob,

If coded correctly, using a join can be more efficient. However, if not
properly written, a join can kill performance.

If you would like help with a join, please contact me.

Donald Raikes
draikes@primenet.com>
====================================
Donald Raikes CPIM
EaglesWing
Making Oracle Fly

draikes@primenet.com http://www.primenet.com/~draikes
===========================