| tablespace [message #197145] |
Tue, 10 October 2006 04:45  |
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  |
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 #197406 is a reply to message #197395] |
Wed, 11 October 2006 03:02 |
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  .
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
