Thread: federated syntqx
08-01-13, 06:45 #1Registered User
Provided Answers: 11
- Join Date
- Apr 2006
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
08-01-13, 08:51 #2:-)
Provided Answers: 1
- Join Date
- Jun 2003
- Toronto, Canada
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.