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.
 
Top