Hi,

> How do I keep FB2 from trying to sort on an index when I'm guaranteed to
> have only one row?

You can extend the GROUP BY clause with a second field (could be the same one) or string constant.
Then the optimizer isn't able to match all fields on an index.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
828 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!