Hi everyone,
i created a linked server to as400 with mssql2005 using odbc driver.

Quering the as400 using openquery function i have quick answer (1").

Making the same query using 4 part name costructor i have slow answer (1'30")

Moreover when i build a view in sql2005 vs as400 tables i have slow response, and is not possible to build an index on a view because of the table is on linked server.

There's somebody who has a suggestion or i have to use 4 part name costructor?
Do you think that a stored procedure is better?

thank's in advance for your answer
Angelo