Subject | QUERY PLAN ? |
---|---|
Author | Adomas Urbanavicius |
Post date | 2005-01-07T14:01:21Z |
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
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