Posted by csimam on 09/02/07 15:40

On Sep 2, 6:18 pm, csi...@gmail.com wrote:
> Hello,
>
> I'd like to start by saying I'm not a DBA, rather I am a Java
> developer. But I'm learning more and more about database design, and
> it's very interesting.
>
> Here is the general issue I'm facing:
>
> Which one is better?
> 1. To perform aggregate queries on data, and use that data to home in
> and perform more detailed analysis? This gives result sets that are
> potentially filled with columns that contain the aggregate data
> repeated across many rows.

By the way, I meant here by homing in: within the same query - using
nested SELECTS. For example, the inner query performs the aggregate
analysis, and returns whatever data we are interested in, and then the
outer query performs another SELECT on the same data, resulting in the
aggregate data being distributed across 'detailed results' from the
outer query.

[Back to original message]