Subject Re: [IBO] SQL statement takes longer to open on a smaller identical DB.....
Author Svein Erling Tysvær
Strange, I see no reason for any of these queries to be slow. Good you
found one that works, but check your indexes when you get time - "the
possibility of duplicate indexes on columns being used in joins" may well
be the reason for the first two being so slow.