Needs expert's input on passthrough quey

S

Sunny

I am comparing between select query and passthrough query. In my application
I have linked all tables to SQL server. Now I want to know if there is any
speed issue on pass through query and select query or both are same?

My query is:

qryOrderStatus
SELECT Client.ClientId, Client.CompanyName, Order.OrderNo,
Order.OrderDate,Order.OrderStatus FROM Client INNER JOIN Order ON
Order.ClientId = Client.ClientId

In my form I use
SELECT * FROM qryOrderStatus WHERE ClientID = "C0001" AND OrderStatus =
"Pending"

Indexs on Table Client:
ClientId

Indexs on Table Order:
OrderNo
ClientId
OrderStatus

If qryOrderStatus is SELECT query will it be slower than passthrough query?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top