There is nothing that you can do, 16 tables in the maximum that Sybase can handle in a single query.
Can you break the query down into several steps, maybe putting the information from several tables into one temporary table before processing the next stage?
More than 16 tables seems to be a very complex query...
Hello,
Actually there is no any rule about table limit in the query.You don't have to divide your query but you have to control your configuration parameters.
There is a parameter that called "Descriptor". It means how many objects can open at the same time.You can control how many descriptor you have for tables, views, indexes etc...
Command :
sp_configure
or
select * from sysconfigures (on master database)
i am actually facing the same query problem. I am joining more than 16 tables and searched the sybase website for this parameter called 'descriptor' and can't find it, and i also can't find it in sysconfigures and sp_configure. I can't break up the query because it is for a view. Sybase was pretty clear on their website that you can't join beyond 16 tables. Would it be possible if you can walk me through the steps you did to accomplish your recommendation aside from looking at sysconfigures and sp_configure.
Have you tried breaking some of the joins up into views that already reference a few of the tables. Then, you could join the views with the rest of the tables in the SELECT.
The only downside that I can think of is since views are only populated as needed, the resources required may be just as bad as an n-table join.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.