Re: DBA FIGHT

denaro wrote:

> These queries are equivalents?

Not always. Where are the explain plans?

> Same results?

TKprof can answer that easily.

> Same performance?

Answer = TKprof.

Both the queries will likely tend towards using nested loops. But the explain plans may even differ a tad when both do use nested loops (like the IN clause causing a SORT).

--
Billy