View previous topic :: View next topic
|
Author |
Message |
hernikiten
New User
Joined: 08 Apr 2005 Posts: 23 Location: india
|
|
|
|
Hi,
What's the maximum number of UNION statements allowed in a single SQL querry(if its treat as a single query as a whole).
Thanks |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
4000 BYTES, if the query has to sort the data to put the results.
In other words, you can have any no of unions but the column length listed in the SQL query should not exceed 400 bytes. This limitation may not be applicable if you are using UNION ALL.
In general,
MAX SQL statement length for V7 was 32KB.
In V8 it is extended to 2 MB.
If you are using UNION ALL the above sql statement length limitations may be applicable. |
|
Back to top |
|
|
|