--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > > > And what's the sintax for it?
> > >
> > > Why do you want to specify a custom plan?
> >
> >
> > We have large tables, some with 120,000 records, and some queries are
> > slow, Im trying to make them the faster possible.
>
> Post the relevant metadata (including indices and
> constraints) and post the queries.
>
> Plans should be used for diagnosing problems.
>
> Writing a custom plan should be avoided.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com

Never mind, I created new index and worked better. thx.