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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br