AS400 linked server query

  • I have an AS400 DB2 table with 3.6 million rows with an index setup on it.  I have set it up as a linked server and I am linking to a SQL Server table with 20 rows in it via an inner join.  However, the AS400 index is clearly not working.  Can anybody help?

    Thanks,

    Chris

  • This was removed by the editor as SPAM

  • I will prefer to have data in SQL Server and then use it in the join within SQL Server and that way it returns result more faster. Try this, create a temp table in your proc, get the data from AS400 using OPENQUERY into temp table (this way you can have AS400 process your request instead SQL Server), and then use this temp table in join with sql server table....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply