Svein Erling Tysvær <svein.erling.tysvaer@k...> wrote:

>Colin,
>the simple answer is to tell you to use PLAN <YourPlan> between the
>WHERE and ORDER BY clause, but it would be better if you showed us
>the plan Firebird chooses and then the plan you think is better.
>Maybe it is possible to tweak the SQL, something that generally is
>better if the plan includes any systemgenerated indexes.
>

Thanks for the reply, Ok no problem getting what Firebird thinks is
the best plan, but i've absolutly no idea what i'd write for a plan.

To Save time, I will try and dig a lot deeper into what plans are
and how they affect the runtimes of the SQL, then I will hopefully
be able to ask a more sensible question with an easier answer.

Sorry to have wasted your time.

Best regards
Colin