| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
Does anyone know if Rdb/VMS has any limits to the number of table
joins that can be performed within a single query?
How about Oracle and Sybase: Do they impose any physical limits?
I have a proposal that requires up to 10 joins on a table. I need to
know how we stack up vs our competition.
Thanks in advance for any help...
Lisa
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 973.1 | 10 tables should work :) | COOKIE::OAKEY | code-free bugs | Mon Aug 12 1991 19:12 | 13 |
� <<< Note 973.0 by DOD2::ROBERTS >>> � -< JOIN limits in Rdb/Oracle/Sybase >- � Does anyone know if Rdb/VMS has any limits to the number of table � joins that can be performed within a single query? Lisa, I don't know about Oracle or Sybase, but Rdb has a limit of 32 "contexts"... which would be roughly equivalent to a table (if you were to join the same table twice in the same query, it would count as 2). Sounds like Rdb is well within the 10 table requirement. | |||||
| 973.2 | DOD2::ROBERTS | Thu Aug 15 1991 16:17 | 3 | ||
thanks bunches...
Lisa
| |||||