Hola Javier,
It is difficult to tell because you did not include
the table structures, relationships, indices, etc.
But... at a first glance we is killing you query
anyways is this:
> FROM
> Bill b, Hour h
The poor db engine is probably creating a huge
temporary table with all
On Thu, 20 Jun 2002, Javier Campoamor wrote:
> Hi,
>
> I have a problem with the next query because it's too slow (>10 seconds) and
> I need to do 10 queries like this one to show a page.
>
>
>
> SELECT
> h.Hour, count(c.Amount) As NumberOfCalls, sum(c.Amount) As Amount
>
