| index files [message #127212] |
Sun, 10 July 2005 00:45  |
NotaDBA
Messages: 6
Registered: July 2005
Location: Richmond, VA
|
Junior Member |
|
|
Could someone please tell me why would i need to place user index files on separate disks?
TIA
NotADBA
|
|
|
|
| Re: index files [message #127218 is a reply to message #127212] |
Sun, 10 July 2005 02:47  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
User index data too is stored in datafiles & is accessed simultaneously/before alongwith the user data, against which the index has been created. This may lead to low disk I/O, thats why its preferred that both are kept on separate disks, if disks are available.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
