jbrugger wrote:

> This is a "never-ending" view (it just ends my patience :)
>
> Plan:
>
> All referenced views are pretty fast, except
> "VW_PRECIOS_UNIT_MAS_DISPENSADOS" which takes ~ 10 secs to complete.
>
> Data Tables have 250000 records (Consumos_Farmacia) and 35000 records
> (Medicamentos)
>
> Is there anything I could do to make this view usable?
>

Hi Jorge !

Hard to tell without viewing the referenced views metadata and the
underlining tables structure and available indices.

> Tell me if you need more info about tables or views involved.
>

Yes ! We need :-)

> Thanks!!!
>

see you !


--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br