> > > 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