Re: Client Server-How is work shared?

In theory, the work should be done on the server, but there are a lot of variables that can effect that...the existence of indices, the type of join, whether there are functions in the query that aren't supported by the engine...

The best resources for you are the Jet Database Engine Programmer's Guide and the showplan option (I think it's documented in on-line help, but if not, check MSDN) , which allows you to see _exactly_ what Jet is doing.

HTH

• Rebecca.

Brian <brian_at_techcat.com> wrote in message news:377246F6.906B6B77_at_techcat.com...
> Hi.
> We query against ORACLE 7.3.3.6 on AIX 4.1.2 with MS ACCESS7.
> In a regular ACCESS query, when select some records from an attached
> ORACLE table of 3million+ records, how much of the selection is done on
> the server and how much is done by ACCESS? Is there a way to check?
> If we use a SQL PASSTHROUGH query, isn't all of the record selection
> done on the server?
> Thanks!
> brian_at_techcat.com
Received on Fri Jun 25 1999 - 01:53:32 CDT