Kbase 12198: No known limit on number of tables & joins in a view
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
No known limit on number of tables & joins in a view
Currently, there is no known limit to the number of tables or the
number of joins you can have when you use a view.
However, when you do a large number of complex joins against either a
large number of tables or a large data set, you can run out of stack
size or buffer limits. Be careful of response time.
To avoid this problem, you can simplifiy joins, do proper indexing,
normalize your database and specify joins in a simpler fashion.
Progress Software Technical Support Note # 12198