Re: cannot have subqueries in CONNECT BY clause

From: Alexander V. Silantiev <silantiev_at_bashkortostan.ru>
Date: Mon, 19 Nov 2001 17:50:40 +0500
Message-ID: <9tav3m$asu$1@poikc.bashnet.ru>

One more question.
If view like
create or replace view classify_rview as select cid,cmaster from classify f
where
exists(select null from classifyrw where cid=f.cid and   username=user)
and exists(select null from classifyrw2 .........) and exists(select null from classifyrw3 ........)

........................

and exists(select null from classifyrwN ........) ;

Whould be the difference in throughput
between the above method and the next joins

select from classify,classify2,,classify3....,,classifyN

Thank you for your lenience.

(sorry for my message to your e-mail) Received on Mon Nov 19 2001 - 06:50:40 CST