| Subject | Re: increase PLAN performance... |
|---|---|
| Author | Svein Erling |
| Post date | 2003-10-28T13:12:06Z |
Lourenço de Paula wrote:
returns after 5 seconds or less.
I often restrict Firebird by preventing it from using certain indexes,
e.g. by using WHERE (<IndexedField> = :value OR 2=0). For more
specific help, please show us your query and Firebirds and your plans.
HTH,
Set
> Hi,30 seconds, but if I specify the plan that Firebird should execute it
>
> I'm executing a SQL statement and it is returning the result after
returns after 5 seconds or less.
>indicate the plan I want?
> Have I any way to increase PLAN performance of my server with out
>Hi Lourenço!
> All help will be usefull.
>
> Thanks.
I often restrict Firebird by preventing it from using certain indexes,
e.g. by using WHERE (<IndexedField> = :value OR 2=0). For more
specific help, please show us your query and Firebirds and your plans.
HTH,
Set