What are the limitations for the number of joins or tables in a SELECT query
in SQL Server 7 and 2000.
Thanks in advance.
Tables per select statement : 256
Columns per select statment: 4096
Quote:> Hi all,
> What are the limitations for the number of joins or tables in a SELECT
> in SQL Server 7 and 2000.
> Thanks in advance.
> Nash Hoogwater
Michael , thanks for your response and recommendations.
I thought of temp tables also . But isn't temp table will be dropped from
the DB when the session ends ??? So , does that mean the temp table need
to be recreated everytime when large number of tables are joined together
It is a query with 9 tables join together . And that query is being
accessed frequently. Among those tables , two of them are fairly big , 20
MB and 7 MB , rests are small , only a few K .