|Subject||Re: [firebird-support] LEFT JOIN much faster than JOIN|
> Hello Josef,Hi!
> 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.