Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: federated syntqx

    db2 ese 9.7 fp7 on windows with federation to sql/server
    when developers request sample data to fill a drop down panel
    they execute against a nickname : select .. from nick fetch first x rows only
    we notice that this results in a complete table read in sqlserver because of a large table : response time is about 1min
    if we specify with a predicate that uses index = no problem
    in sqlserver there is anyhow a possibility to specify select top 10....
    which is equivalent for fetch first x rows only
    the question would be : as this option is not being translated to sqlserver, is there a possibility to have this translated or to force this option.. ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can try setting the PLAN_HINTS server option to 'Y', DB2 may be able to send additional information to the remote. Alternatively, you can issue SET PASSTHRU <server name> before executing the query, in that case the query text will be sent to the remote without DB2 parsing it. Obviously, in that case you will use the SQL Server syntax.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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