Home » RDBMS Server » Server Administration » Inserting Data become Slow why?
Inserting Data become Slow why? [message #197417] Wed, 11 October 2006 03:48 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: tablespace
Next Topic: How to free disk space.
Goto Forum:
  


Current Time: Tue Dec 06 12:24:00 CST 2016

Total time taken to generate the page: 0.08930 seconds