"arhampshire" <arhampshire@...> wrote:

>
> select A, min(B), max(B), count(*)
> from myTable
> where A = 10
> group by A;

Do you use some query generating tool or is it just a bad example? I see no
reason to use a GROUP BY clause here.

> Are there any tips, or pointers to improve performance of queries?

Could you please show a plan for this query?


Dmitry