| Subject | RE: [firebird-support] Force query plan to filter before join (Arno) |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2012-02-21T10:02:20Z |
Hi Arno!
Is Firebird intelligent enough to use an index for
PROJECT."ASSIGNMENT_STATUS" != 'UNASSIGNED'
when over 99% of the data contains 'UNASSIGNED'? I thought we had to wait for Firebird 3 to see histograms and that 'not equal' would not be able to efficiently use an index before that?
Eagerly awaiting your reply!
Set
Is Firebird intelligent enough to use an index for
PROJECT."ASSIGNMENT_STATUS" != 'UNASSIGNED'
when over 99% of the data contains 'UNASSIGNED'? I thought we had to wait for Firebird 3 to see histograms and that 'not equal' would not be able to efficiently use an index before that?
Eagerly awaiting your reply!
Set