Subject Re: [firebird-support] How to plan a query
Author Alexandre Benson Smith
danyschaer wrote:
> Hi Forum;
> I want to ask if someone can show me some links for reading and
> understanding how to define special plans for my queries.
> Thank you.
> Dany
I think the best advise I can make is to not do it...

Plans are dynamic things, that could and should change along the time
and as the data distribution changes.

The first question I will ask is: Why do you think you need to provide a
fixed plan ?

If you think you are getting slow performance on some queries, I think
you will get very good advices from the people on this list if you
provide the table structure, the query you are having trouble, the plan
used by the engine, the indices on those tables and information about
it's selectivities.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil