At 10:10 10.01.2003 +0000, you wrote:

>I never specifie anything aout plan.

IB/Fb needs a plan to execute whether you specify it explicitly or not.

>Should I do that ?

Normally not, but you should examine the generated plan, e.g. by preparing
the statements using IB_SQL (free from www.ibobjects.com).

>Would it bring up speed ?

It may reveal why things are slow, thus indicating how you can improve it.
It can be very useful for SELECTs. It will not help much for INSERTs I'm
afraid, but if a couple of persons are executing selects using a bad plan
it can make the whole system come to a crawl.

>I have one index which actually in this customers case alwasys holds
>the same value ('Ingen længde').
>Should I drop this ?

Definitely, the only thing this index does is to slow things down (mainly
updates/deletes, but it will also slow down selects if chosen for a plan).

Set

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation