Subject Re: [firebird-support] Slow view
Author Ann W. Harrison
At 02:36 PM 7/13/2004, Luciano Rodrigues wrote:
>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.