onds (or less
if possible).
We're going to try using VIEW's to see if that helps. Any other thoughts
would be appreciated.
Best,
Don
Perrin Harkins wrote:
>
> On Dec 30, 2007 1:50 PM, donr2020 <[EMAIL PROTECTED]> wrote:
>> Our search engine does a master query INNER
Our search engine does a master query INNER JOINed to a series of COUNT (*)
subqueries that return what the number of results would have been had the
user chosen different "filters" (or no filter at all). As an example:
SELECT Main.Col1, NoFilter.TotCount, Filter1.SubCount, etc. FROM
(
SELECT Col
