tymorrisy wrote:

> ...
>
> The reason I am asking is I am having a problem with a Win 2k3 server
> and firebird 1.5.1.
>
> I can see all my tables and indexs. I can copy the db to a win 2k
> server and it runs fine. But on win 2k3 running this command will
> cause firebird to restart its service:
>
> select count(*) from capture where trandate > '12/01/2004' and
> trandate < '12/12/2004' plan (capture index(cdateindx))
>
> If I run this command it works fine:
>
> select count(*) from capture where trandate > '12/01/2004' and
> trandate < '12/12/2004'
>

The PLAN clause is there to get around problems, not to create them :-)
So, just drop the PLAN clause if it hurts performance.

BTW, a PLAN clause should not cause Firebird to restart.


--
Aage J.