Does this parm provide equivalent performance of a recordsource that has the same where clause in the query SQL ?
Full Version: Openreport Parm : Wherecondition Parameter
Hi,
That's a good question, and my guess would be "yes" but one way to find out is to try it.
Just my 2 cents...
That's a good question, and my guess would be "yes" but one way to find out is to try it.
Just my 2 cents...
Consensus is that it's likely only to be significant for large or complex queries.
This big question is: does the Access query optimizer get called for the Where Clause parm ?
Likely not.
This big question is: does the Access query optimizer get called for the Where Clause parm ?
Likely not.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.