Subject Re: How to force a plan on a query
Author colincoleman2002
Svein Erling Tysvær <svein.erling.tysvaer@k...> wrote:
>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