Query size limits

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • --CELKO--
    #1

    Query size limits

    What are the current query size limits (bytes) for various DB2
    products?
    Tags: None
    • Mark A
      #2
      Re: Query size limits

      "--CELKO--" <jcelko212@eart hlink.netwrote in message
      news:258b1bc3-9ae1-4213-85b9-8e296f43dd27@l6 4g2000hse.googl egroups.com...
      What are the current query size limits (bytes) for various DB2
      products?
      The limits are in one of the appendixes of the SQL Reference. If there is a
      SQL Reference Vol 1 & 2, then try Vol 1 (LUW).


        Comment

        • Serge Rielau
          #3
          Re: Query size limits

          --CELKO-- wrote:
          What are the current query size limits (bytes) for various DB2
          products?
          DB2 for LUW supports 2MB of statement text. The internal size/complexity
          is limited by memory. If things get too complex the optimizer will dial
          back to a greedy algorithm.

          Cheers
          Serge
          --
          Serge Rielau
          DB2 Solutions Development
          IBM Toronto Lab

            Comment

            Previous template Next
            Working...