Bill of materials, CONNECT BY clause ?
From: Uwe Diekmann <diekman_at_iw.uni-hannover.de>
Date: Sun, 7 Mar 1993 20:43:10 GMT
Message-ID: <1993Mar7.204310.22622_at_newsserver.rrzn.uni-hannover.de>
Date: Sun, 7 Mar 1993 20:43:10 GMT
Message-ID: <1993Mar7.204310.22622_at_newsserver.rrzn.uni-hannover.de>
Hallo,
Is the CONNECT BY clause specific to Oracle or is it standard SQL ?
Is there a better way to solve the so called 'bill of materials'-problem, i.e. the query for elements in hierarchical (or direct acyclic graph) structures which can be represented by a simple binary relation ?
I think the CONNECT BY clause does not work within joins. Subqueries are slow, comparing them to joins.
Thanks in advance.
********************diekman_at_iw.uni-hannover.de*******************
* Uwe Diekmann Tel: INT-49-511-762-3906
* Institut fuer Werkstoffkunde FAX: INT-49-511-762-5245
* Universtitaet Hannover
* Appelstrasse 11 A
- W 3000 Hannnover 1; Germany