Hi Karol,
perfect! I usually say that I hate DBs but
the more I gain deep insights I start to like it.
Thank you for your help!
Matthias
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] <
firebird-support@yahoogroups.com> schrieb am Mi., 4. März 2020, 19:38:
>
>
> Pseudo inner join
Pseudo inner join is left join with where clause about not null from left
joined tableSelectFromTable1 t1 left join Table2 t2 on
t1.id=t2.id_t1Wheret2.id is not nullRegards,Karol Bieniaszewski
null
Hi Karol,
Thanks for your reply.
Can you outline how I would do a "inner join to pseudo inner join without
affecting resultset".
Matthias
On Wed, Mar 4, 2020 at 10:12 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi
>
> You can always change inner join to
HiYou can always change inner join to pseudo inner join without affecting
resultset. But better you should find the reason of this slowdown as it looks
like index without recent stats or wrong indexing in join. But it also can be
something else.Regards,Karol Bieniaszewski
null
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
This advice should be oppositeYou should not have order by in the view.Only
exception is when you always do only simple select * from myviewRegards,Karol
Bieniaszewski
null
The optimizer uses the selectivity of an index to decide to use or not to use
an index.
Can You post the DDL of the table and the view?
Did You order inside the view or outside the view?
Example:
MyView = select * from Table order by Colum desc;
Select * from MyView
Or
MyView = select *
Can You check the selectivity of the index? Perhaps You could recalculate that
selectivity: http://www.firebirdfaq.org/faq167/
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2020 12:41
An: firebird-support@yahoogroups.com
Betreff: Re: