Home » RDBMS Server » Performance Tuning » Querying the database faster (8.1.7.4)
Querying the database faster [message #377423] Mon, 22 December 2008 23:49 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: Querying the database faster [message #377438 is a reply to message #377423] Tue, 23 December 2008 01:25 Go to previous message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
Thanks for your reply.
Previous Topic: Query tuning
Next Topic: Full table scan when one type of records
Goto Forum:
  


Current Time: Fri Dec 09 13:59:25 CST 2016

Total time taken to generate the page: 0.13805 seconds