| Inserting Data become Slow why? [message #197417] |
Wed, 11 October 2006 03:48  |
saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore
|
Junior Member |
|
|
Hi all
I have a Table in my production server per day in a particular time it is getting populated up to 10k record,it is fine
in above table if we run query select it is very slow,so that we created index's on this table now retriving very fast(campare early) but inserting Data become very slow(Compare early)
why,to make fast Insert what we have to do
can somebody help us
saiyshnav
|
|
|
|
| Re: Inserting Data become Slow why? [message #197431 is a reply to message #197417] |
Wed, 11 October 2006 04:38  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Presence of index, will slow the insert but may help the select query.
So it is expected.
You disable indexes before loading and enable them back.
Make sure you are collecting the statistics on these tables/indexes. Else, indexes are not of much use.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
