Linked table or Pass Through Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wanting to use data from some Oracle tables. Is it generally
better/faster to use linked tables or pass through queries?

What are the advantages/disadvantages of each?

Thanks!
 
Properly used (i.e.: dynamically rewriting the SQL to include any
appropriate Where clause information), pass-through queries are probably
going to be faster, as the query runs on the server and only passes back the
matching records.

However, pass-through queries aren't updatable, so if you're planning on
writing to the database, you may find them more of a pain. It is possible,
but more work. I've built an application that goes against SQL Server using
pass-through queries to return the data. I use unbound forms a lot, and call
stored procedures (using pass-through queries) to update the data.
 
Assuming you have criteria in your pass through query, it should be faster.
Fewer records/less data = faster. However, if you're just doing a select on
an entire table, you probably won't notice much difference between a pass
through vs linked table.

Advantages/disadvantages would center on whether the pass through returns
results that can be edited and what your needs are. If you need to edit and
the pass through query doesn't allow for it, you'll have to do some extra
code work to do.
 
Back
Top