Hello, I tried the sorting inside and outside a minimal view and it actually worked in both cases without non-indexed reads, meaning FAST.
By stripping down my complex view it turned out that a "inner join" with another table inside the view killed my performance. I will now try to evaluate if I can replace it with a simple "left join" which shows good performance. Matthias On Tue, Mar 3, 2020 at 3:36 PM liviuslivius [email protected] [firebird-support] <[email protected]> wrote: > > > This advice should be opposite > You should not have order by in the view. > Only exception is when you always do only simple select * from myview > > Regards, > Karol Bieniaszewski > > >
