| Subject | Re: [firebird-support] best query to find the first row ordering by a column, with a constraint |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-03-01T16:47:51Z |
korkless wrote:
Firebird indexes are uni-directional. You need a descending
index to get either a MAX or a FIRST x ... ORDER BY ... DESC.
Good luck,
Ann
Firebird indexes are uni-directional. You need a descending
index to get either a MAX or a FIRST x ... ORDER BY ... DESC.
Good luck,
Ann