At 02:36 PM 7/13/2004, Luciano Rodrigues wrote:

>Hi,
>
>This view get 248.538 reads from EMPRESAS table and
>165.692 reads from PARAMCONTROLE table, even I use any kind of result
>set limitation like "where", "first 1".

That's some view. My only suggestion is that you change the
SQL-89 implicit join (the one indicated by a comma) to a
SQL-92 explicit JOIN.


Regards,

Ann