Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    5

    Unanswered: How to adjust the work table limit?

    There is a SQL statement:
    select .... from table1 group by c1, c2, c3

    Sybase cannot execute it and reported 'The current query would generate a key size of 763 for a work table. This exceeds the maximum allowable limit of 600'.

    But this statement can easily be executed in MSSQL and MySQL also ACCESS.

    I won't modify statement because it has been very simple.

    Can I adjust the Sybase work table limit? And how?

    Thank you.

  2. #2
    Join Date
    Jul 2004
    Posts
    2
    Hi,
    I think you have to reduce the total size of the columns named in the group by clause.

    The "Troubleshooting and Error Messages Guide" may help you.

    http://manuals.sybase.com/onlinebook...15165;pt=15380

    Bye.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •