>> and what exactly will this help regarding performance?
>> (this is urban legend)

>A flamebaiter on the list? ;-)

>Seriously, depending on the number of indexes and the speed of your disk
>controller vs. the speed of your disks, you can get a 50% increase in
>write speeds.

Yes because of pure luck. Depending on the write requests you can get 0% performance increase. Oracle is writing first to the buffer cache and the db-writer later writes the blocks to disk. So wichever file db-writer is writing to, as long as they are separeted, you'll see a performance gain. But this has nothing to do with index versus data tablespace. It is all about the write pattern of the application.

For sure you can find a lot of information on the web, but why not start with
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:901906930328

Cheers, Leo


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting