Home » RDBMS Server » Server Administration » tablespace
tablespace [message #197145] Tue, 10 October 2006 04:45 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
I want to increase the size of tablespace .if i have to query from table which is in changed tablespace ,let me know It will affect performance or not ??.
Re: tablespace [message #197357 is a reply to message #197145] Wed, 11 October 2006 01:07 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
venkatraghavan wrote on Tue, 10 October 2006 11:45

I want to increase the size of tablespace .if i have to query from table which is in changed tablespace ,let me know It will affect performance or not ??.



If you extent your tablespace it will not affect your performance when reading a table that is in that tablespace.


Re: tablespace [message #197395 is a reply to message #197357] Wed, 11 October 2006 02:23 Go to previous messageGo to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
thanks.

if suppose i am going to insert 10000 records , will it affect performance ?
Re: tablespace [message #197406 is a reply to message #197395] Wed, 11 October 2006 03:02 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
venkatraghavan wrote on Wed, 11 October 2006 09:23

thanks.

if suppose i am going to insert 10000 records , will it affect performance ?



The more data the more it will affect performance, that is normal. It would be funny if it was visa versa Smile.
But if you index your tables right, and write good sql statements then there would be no problem to get your data in an exceptable amount of time.

Previous Topic: Start up problem in oracle 9i on Windows XP professional 2002
Next Topic: Inserting Data become Slow why?
Goto Forum:
  


Current Time: Sat Dec 10 14:40:11 CST 2016

Total time taken to generate the page: 0.07944 seconds