Subject QUERY PLAN ?
Author Adomas Urbanavicius
Hello,

We got situation : we make selection from huge FB table, where is lots
of indexes, so to optimize perfomance I need to make selection, with
plan described.
But, (TIBOQuery) after such actions : qr->Add(s), where s = "select *
from A1 where..... PLAN(INDEX P1....) ORDER BY ....,
qr->Open()
I get error "index P1 cannot be used in specified plan". BUT same sql
statement runs clearly in FB managers, such as Db Workbench, EMS Manager
with no problems....
Can I somehow solve it ?
Adomas