Neither Access nor Excel are relational database management systems (RDBMS); since they
can keep all data in memory and just rewrite, there isn't any real magic involved.
If your source table is spatially fragmented (that is, there is no correspondence between
location and row number -- when you draw a single layer at 1/4-1/10 of the total extent
and features render in apparently random order), then there could still be a large benefit
to draw (and other spatial search) performance with row optimization. It only becomes
obvious on tables with a 300k+ rows or more, but the difference is measureable with as
little as 10k rows.
- V