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