COURSE of the MONTH

SQL View - PT vs. Table Link

Access 97/2k,2k7, SQL 2k5
I currently have SQL views linked as tables in my access db. Are there any benefits to changing it from a link to the view to a pass through query executing the view? (Besides the con of the PT being read-only)

Who is Participating?

The only work client side using the view is the Order By or if you put further where clauses on the view when you open it.

If you have a view on the server such as IS_Emp_Vw:
SELECT *
FROM EMPLOYEE_TABLE
WHERE Active = 1
AND Dept = 1357

and link it to an Acc DB as a table all the work is done on the server. Now, if you link it as a table an then do a query against it as
SELECT *
FROM dbo_IS_Emp_Vw
WHERE Emp_Name like "P*"
The where clause is does client side, but the rest is done server side. The PT just makes the Emp_name clause server side as well.

so right now i just have my view linked as a table to access. so all of the work of creating the view is on the server. i just thought that if i changed it to a PT query in access, since it does not use jet at all with the PT, that there may possibly be a performance increase.