Subject Re: [firebird-support] LEFT JOIN much faster than JOIN
Author Josef KokeŇ°
> Hello Josef,
> I've never had that issue using Firebird, but some time ago I had a
> similar behavior with SQL Server and the responsible was a fragmented
> index. May be you should take a look to your indexes design or rebuild
> them via backup/restore.


That should not be the case here, as all my tests were performed right
after a backup/restore cycle.