Union view limits

Posted in 2009

Topics: SQL Development & Query Writing, Platform-Specific Issues

fandelau — Wed, 21 Oct 2009 11:34:48 -0700 (PDT) — source: Usenet: comp.databases.informix

Guys, Is anyone aware of a limit on the number of select statements that a union view can handle? I have tested a union view with 100 "select * " from 100 different tables, with no problem. Just wondering if there is a ceiling, or if the sky is the limit... ^_^ I'm working on 11.10.FC3 on Solaris. Thanks in advance! Ramon.

↪ replying to fandelau

Art Kagel — Wed, 21 Oct 2009 14:41:58 -0400 — source: Usenet: comp.databases.informix

The only limit that I am aware of is the limits on the length of a single SQL statement which is 65535 characters, so if each table and column name is two characters long that works out to about 3449 SELECTS in an maximum length UNION less the characters needed to define the VIEW. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 21, 2009 at 2:34 PM, fandelau <fandelau@gmail.com> wrote: > Guys, > Is anyone aware of a limit on the number of select statements that a > union view can handle? I have tested a union view with 100 "select * " > from 100 different tables, with no problem. Just wondering if there is > a ceiling, or if the sky is the limit... ^_^ > I'm working on 11.10.FC3 on Solaris. > Thanks in advance! > > Ramon. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to fandelau

Andrew Clarke — Thu, 22 Oct 2009 09:51:54 +1100 — source: Usenet: comp.databases.informix

> Guys, > Is anyone aware of a limit on the number of select statements that a > union view can handle? I have tested a union view with 100 "select * " > from 100 different tables, with no problem. Just wondering if there is > a ceiling, or if the sky is the limit... ^_^ > I'm working on 11.10.FC3 on Solaris. > Thanks in advance! As the complexity rises, you might run into time limits! The expression "heat death of the universe" springs to mind...