> Who could explain in details, how the engine performs queries with ORDER

BY

> clause.

I wish that I could but I don't feel qualified.

The best place to find someone who will answer your question is on the
IB-Architect@egroups.com list.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com