Hi Nathan,
> The problem gets into the multiple where fields in the where clause.
> There could be up to 9 different where parameters.
I could be wrong, but your statement above screams out that your
database may not be "normalized". By this I mean that perhaps you have
a lot of null values
Nathan Biggs wrote:
> I was hoping that someone could help me with optimizing this query.
> Basically I need to return totals from an large database (> 1million
> records in the table). There needs to be two different totals one by
> "a" and one by "b" where "a" and "b" could have up to 100
On Thu, Feb 14, 2008 at 2:26 PM, Nathan Biggs <[EMAIL PROTECTED]> wrote:
> I was hoping that someone could help me with optimizing this query.
> Basically I need to return totals from an large database (> 1million
> records in the table). There needs to be two different totals one by
> "a" and
I was hoping that someone could help me with optimizing this query.
Basically I need to return totals from an large database (> 1million
records in the table). There needs to be two different totals one by
"a" and one by "b" where "a" and "b" could have up to 100 rows each. So
totals for up
4 matches
Mail list logo