Subject Re: [firebird-support] Re: BAD BLR ??? Whats? Select Sum in View
Author Alexandre Benson Smith
Kurt Schneider wrote:
> Hello
> Thanks for Help Ann.
> "or to simplify the query." its a really complex, the view is result and
> return solds of movimention. i'm work with maximum simplify query, and the
> view have 235 lines. She contains UNIONS and GROUP BY and 30 relationship..
> it's really complex.
> An Store Procedure isv not applicated in this case... also for test.

What about to de-normalize some data and maintain it via triggers to
reduce the number os tables involved ?

(ouch !, better to open my umbrella because rotten tomatoes will come to
my direction :-) )

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil