Subject Re: [IBO] SQL Plan
Author Helen Borrie
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.


select first_name, last_name from employee
where last_name starting with 'J'