> From: xaladjov <aladjov@...>
> Is it possible to change physical order of a interbase table
> to correspond to some index?

If you just insert rows into empty table, their order will be preserved,
until you begin to modify (update/delete) them.
So, if you intend to distribute read-only database,
it makes sense to create such database by inserting data into it ordered.

Because speed improvement can be really huge,
you can (if you can afford it) sometime shutdown production database,
dump table to external file/database, empty table, garbage collect it,
and load data back.

Ivan
http://www.volny.cz/iprenosil/interbase