Re: default tablespace

Stephen,

> one possible
> example that comes to mind is where you have a large number of
> similtaneous queries by a key value that are widely dispersed accross

Or you have one process running that accesses an index and a table. Sound remarkably like benchmarking? My personal theory is that is where this practice originated. People doing benchmarking would split the table and index to different devices, got a good perfomance increase, then that technique migrated into the database lore.

As has been pointed out, most Oracle databases have many processes, many tables and indexes.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l