| Storage indexes in different Tablespaces [message #55468] |
Sun, 26 January 2003 11:55  |
Goldy
Messages: 2
Registered: December 2002
|
Junior Member |
|
|
I have an Oracle 8.1.7 on Win NT 4.0.
Both data and indexes are store in one tablespace (USERS) after migration from oracle 7.
Can I raise performance of my system by storing indexes in separate tablespace (INDEXES)?
If so, what rate of improving can i take?
|
|
|
|
| Re: Storage indexes in different Tablespaces [message #55483 is a reply to message #55468] |
Mon, 27 January 2003 06:14  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
definatly storing indexes and table data seperatly will improve the performance.
since you can BALANCE THE the disk read and disk write.
and you can avaoid fragmentation (since indexes are highly framgmented.)
rate of improving, cannot determined, unless u bench mark the system.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
