Re: Is this too slow?

On 13 Jul 2001, usenet_at_smalltime.com wrote:

> As an example, this particular query takes about 5 to 6 minutes
> to run:
>
> SELECT count(*), experiment.experiment_id
> FROM experiment, datum
> WHERE experiment.experiment_id = datum.experiment_id and
> experiment.scientist_id = 4
> GROUP BY experiment.experiment_id;

How long does
SELECT count(*)

FROM      experiment, datum
WHERE     experiment.experiment_id = datum.experiment_id and
          experiment.scientist_id = 4 

take to run?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.