Hi Ann,

> Err, actually, Jim and I just talked about the way sort works,
> and unless something has changed, nothing is "moved around on
> disk". When a sort run is larger than the memory allowed, it
> is written out in sorted order. When all records have been
> sorted, the runs are merged. If that's right, then runs are
> both read and written sequentially, which seems like the best
> of both worlds... given that you've got a world where the
> sorted set doesn't fit in memory.

When does the merging (of multiple runs) happen? [By fetch, on first execute, ..?]
Is the final merge only in memory or also written to disk?

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