On Fri, Sep 2, 2011 at 6:24 PM, Markus Ostenried <[email protected]>wrote:
> On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane > <[email protected]> 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]
