Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Exclamation Unanswered: -874 optimizer error

    When i have some outer joins and other simple joins i get an optimizer error (-874 optimizer error),i found that it is a bug, do anybody knows how fix it?
    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    This could be a bug, what Informix version are you using ?.
    If you run update statistics with distributions, i suggest that drop distributions the statistcs on the table and re-run the SQL.
    Or not run upd. stat. on columns float type.

    Gustavo.

Posting Permissions

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