>If you override the default NULLs placement, no index will be used for >sorting. In Firebird 1.5, that is the case with NULLS FIRST. In 2.0 and >higher, with NULLS LAST on ascending and NULLS FIRST on descending sorts. > >but i need the index :(
Why do you need an index for sorting, Stephane? Generally, indexes are great for JOIN and WHERE clauses, not for sorting. Do you have millions of records and cannot eliminate 99% of them through a WHERE clause? If so, are all of the records of interest or only a fraction? My guess is that there may be other ways to solve your problem that involves a WHERE clause... Set
