Subject | Re: How to optimize view to work faster |
---|---|
Author | Sasa Mihajlovic |
Post date | 2007-12-09T23:13:52Z |
Hi,
here the plan:
Plan
PLAN JOIN (JOIN (Q X ORDER PK_ROBFAKTURA, Q Y INDEX
(FK_ROBFAKTURAS_1)), Z INDEX (PK_ROBFAKTURA))
Adapted Plan
PLAN JOIN (JOIN (Q X ORDER PK_ROBFAKTURA, Q Y INDEX
(FK_ROBFAKTURAS_1)), Z INDEX (PK_ROBFAKTURA))
I'm using IBExpert for DB development and UIB for application
development. I think that is a lillte closer look on my problem!
Thnaks again...
here the plan:
Plan
PLAN JOIN (JOIN (Q X ORDER PK_ROBFAKTURA, Q Y INDEX
(FK_ROBFAKTURAS_1)), Z INDEX (PK_ROBFAKTURA))
Adapted Plan
PLAN JOIN (JOIN (Q X ORDER PK_ROBFAKTURA, Q Y INDEX
(FK_ROBFAKTURAS_1)), Z INDEX (PK_ROBFAKTURA))
I'm using IBExpert for DB development and UIB for application
development. I think that is a lillte closer look on my problem!
Thnaks again...