Subject | Re: [firebird-support] LEFT JOIN much faster than JOIN |
---|---|
Author | Josef Kokeš |
Post date | 2013-08-02T11:58:44Z |
> 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.
Josef