16 table limit 
Author Message
 16 table limit

SQL SERVER v6.0

I am involved with a database in which I consistently
battle the 16 table limit in joins.  It's to the point
where my manager is thinking about dumping SQL Server and
purchasing one of the big guns.  I know that many of you
out there have experienced my frustration and wonder how
the you worked around this limitation?

Does anyone know if Microsoft plans to eliminate this pain
in any of the next releases?

I don't see this limitation in other vendors dbms nor in
MS-Access.

Thanks in advance for your consideration.
--Ken



Sat, 24 Jun 2000 03:00:00 GMT
 16 table limit

Why not use views to do some of the join work ???
MIKE.

Quote:
> I am involved with a database in which I consistently
> battle the 16 table limit in joins.  It's to the point
> where my manager is thinking about dumping SQL Server and
> purchasing one of the big guns.  I know that many of you
> out there have experienced my frustration and wonder how
> the you worked around this limitation?



Mon, 26 Jun 2000 03:00:00 GMT
 16 table limit

Quote:

>Why not use views to do some of the join work ???
>MIKE.
>> I am involved with a database in which I consistently
>> battle the 16 table limit in joins.  ...

Whether you nest views of views or write a single huge select
statement, you are limited to a total of 16 tables.  Views do not
provide any more tables.

Tony Scandora, Argonne National Lab, 630-252-7541



Mon, 26 Jun 2000 03:00:00 GMT
 16 table limit

Is that true??? the documentation does not imply that. Maybe I didn't
explain myself well:
consider a simple join:
  select a,b,c from t1, t2 where t1.b=t2.b
that involves TWO tables.
it can be rewritten as
  select a,b,c from v1
where v1 is a view defined as the original select.
That way you reduced the number of tables/views in the statement from 2 to
1. you can usually do this to reduce the number of tables/views in a select
(unless SS expands the statement according to view definition...)
MIKE.



Quote:


> >Why not use views to do some of the join work ???
> >MIKE.
> >> I am involved with a database in which I consistently
> >> battle the 16 table limit in joins.  ...

> Whether you nest views of views or write a single huge select
> statement, you are limited to a total of 16 tables.  Views do not
> provide any more tables.

> Tony Scandora, Argonne National Lab, 630-252-7541




Thu, 29 Jun 2000 03:00:00 GMT
 16 table limit

Quote:

>Is that true??? the documentation does not imply that. Maybe I didn't
>explain myself well:
>consider a simple join:
>  select a,b,c from t1, t2 where t1.b=t2.b
>that involves TWO tables.
>it can be rewritten as
>  select a,b,c from v1
>where v1 is a view defined as the original select.
>That way you reduced the number of tables/views in the statement from 2 to
>1. you can usually do this to reduce the number of tables/views in a select
>(unless SS expands the statement according to view definition...)

SQL Server expands the statement according to the view definition.
Whether you use the first select from two tables or the second from the
view, the query optimizer ultimately has to fetch rows from two tables,
and that is where the 16 table limit comes from.

Tony Scandora, Argonne National Lab, 630-252-7541



Fri, 30 Jun 2000 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. SQL Server 6.5 and 16 Table Limit

2. SQL Server 16 table limit

3. 16 Table limit in Query

4. Help - 16 table limit

5. 16-table Limit in SQL Queries

6. 16 tables limit

7. 16 table limit in ISQL ?

8. 16 table limit in queries

9. 16 table limit in a query

10. 16 table limit on 6.x

11. 6.5 - 16 table limit in SELECT

12. 16 Table Limit


 
Powered by phpBB® Forum Software