| Subject | Re: What the problem with the optimizer and my SQL? |
|---|---|
| Author | emb_blaster |
| Post date | 2009-02-02T17:07:38Z |
By the Way,
Almost forgot... FB2.0.5 do not selected the best plan in my case...
It is now selecting Plan:
PLAN JOIN (P NATURAL, I INDEX (RDB$FOREIGN58), V INDEX
(RDB$PRIMARY34), SN INDEX (RDB$PRIMARY29))
Almost forgot... FB2.0.5 do not selected the best plan in my case...
It is now selecting Plan:
PLAN JOIN (P NATURAL, I INDEX (RDB$FOREIGN58), V INDEX
(RDB$PRIMARY34), SN INDEX (RDB$PRIMARY29))