On Tue, Mar 29, 2005 at 15:12:24 +0100, T E Schmitz <mailreg@numerixtechnology.de> wrote:
>
> Shall do.
> But am I correct in assuming that I should place an index on the group
> by (TRANSAKTION.ORIGIN) column?
This will mainly help when joining the view to another table. This would
also allow using an index scan instead of a sort in for DISTINCT which
may be faster in some cases.