On Fri, Sep 2, 2011 at 6:24 PM, Markus Ostenried <macnoz@...>wrote:

> On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane
> <svanderclock@...> wrote:
>
> > but i need the index :(
>
> What's the performance if you use an (ugly) hack like this:
>
> Create a column NULLFLAG (with values 0 and 1) with an index on it and
> in a trigger set it according to your NULLable column.
> Then in the SELECT statement do
> ORDERY BY NULLFLAG, FIELD
> and Firebird should use both indexes.

No, unfortunately, it won't. When using navigational index access, Firebird
can use only one index.


Good luck,

Ann

>

[Non-text portions of this message have been removed]