At 09:33 AM 27/01/2005 +1300, you wrote:

>Hi All
>
>This is probably a silly question but ...
>If I am using a TIBOQuery component, how do I override the prepared plan
>with my own?

Just include it in the correct place in your SQL as a PLAN clause. It's
the last clause in the statement, other than ORDER BY, which has to follow
any PLAN clause.

e.g.

select first_name, last_name from employee
where last_name starting with 'J'
PLAN (EMPLOYEE INDEX (NAMEX))

Helen