Oracle table space performance
Posted on 2011-03-19
We are using oracle 9i we have a series of 2000 update statements to update all the tables in this database. The current table space in the database is 300 mb , while database size is 26 GB. Our DBA says table space will not affect performance doing update statements. Is this true , if not is there any documentation that proves this?
Note : We are doing this is test database with temp table space of 300mb while production has 23 GB table space.
We already know what statements are problematic.