Subject | Maximum number of union and left join |
---|---|
Author | elitalaw |
Post date | 2004-04-14T07:03:36Z |
Hi all,
I've tried to execute a query that consist of 18 unions. It gave me
an error 'BAD BLR - invalid stream' and sometimes a lost connection
to the database.
It happened to me before when i tried to create a stored procedure
with more that 20 left joins.
My question is, what is the maximum number of union a query can
contain? the same goes to left join.
thanks,
eLita
I've tried to execute a query that consist of 18 unions. It gave me
an error 'BAD BLR - invalid stream' and sometimes a lost connection
to the database.
It happened to me before when i tried to create a stored procedure
with more that 20 left joins.
My question is, what is the maximum number of union a query can
contain? the same goes to left join.
thanks,
eLita