Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    120

    Unanswered: porting option from SQL Server

    Hi all,
    I'm trying to port a query from SQL Server to DB2.

    In the query it's used:
    OPTION ( MAXDOP 1, RECOMPILE )

    Does anybody have an idea of how to write it for DB2?

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are migrating, I would not do the optimizer hints part.
    If you find a performance issue, you can look at how best to optimize it for DB2 rather than using SQL Server's strategies.

    HTH


    Quote Originally Posted by Robert1973 View Post
    Hi all,
    I'm trying to port a query from SQL Server to DB2.

    In the query it's used:
    OPTION ( MAXDOP 1, RECOMPILE )

    Does anybody have an idea of how to write it for DB2?

    Thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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