Hi, I have the following problem: I need to perform query on oracle linked server. When I do select with where clause from OPENQUERY function, it works fine - below one second. When I want to create view using OPENQUERY and pass parameter to the view, it takes around one minute. It seems that the WHERE clause is applied on SQL Server side. I found info claiming that if I use UDF with parameter, all processing is done on Oracle, but it dosn't seem to work in this way. The only solution I can think of is dynamically building query in sp but I'm sure there must be a better way to do it. Any ideas? Thanks. mojza