Hello,

> Can we get an idea of the amount of memory being consumed by category,
> for instance, the amount used to store the results of the sub-query,
> the amount consumed by intermediate joint results, the amount used by
> the sort, the amount used by the grouping and aggregation. The more
> detail the better of course, but I understand there may be a limit to
> how much detail we can have available.
>

You can use MON$ tables in 2.1 and 2.5 versions of Firebird to get some
information about memory consumption.
Though if you would explain why you are looking for such information,
you would get more useful answers.

Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)



[Non-text portions of this message have been removed]