| Querying the database faster [message #377423] |
Mon, 22 December 2008 23:49  |
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
|
Junior Member |
|
|
I am new in this area.Could you please answer to this question?
do you know if smaller datafiles will make querying the database faster?
We can use the AUTOEXTEND option to increase the size of datafile to the max limit.
Which option will be better for the performance?
AUTOEXTEND or Adding a datafile
|
|
|
|
| Re: Querying the database faster [message #377436 is a reply to message #377423] |
Tue, 23 December 2008 01:15  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
It all depends, for example:
If you don't use ASM, adding new datafiles will give you better control over file placement.
AUTOEXTEND is great for those small databases where you don't care about performance or where you are using ASM to take care of the striping.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
