Home » RDBMS Server » Server Administration » Speed Boosting of the Database Performance
Speed Boosting of the Database Performance [message #58343] Sun, 17 August 2003 00:57 Go to next message
Everest
Messages: 17
Registered: November 2001
Junior Member
Hello,
I have a database and several tables and several data in those tables.......
There are lots of Indexes and now the problem occurring is about the speed during the data entry...... How can I speed up for the data Entry and data execution.... my oracle version is 8i and front end is D2k Form version 6.0
Hope to Hear from you soon......
Yours,
Everest
Re: Speed Boosting of the Database Performance [message #58356 is a reply to message #58343] Mon, 18 August 2003 06:21 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
a fact is , too many indexes will hinder the insertion of data ( because the indexes also need to updated).
but without indexes, your retrieval would be a pain.
Only in DSS / warehouse/ods/marts we would disable all the indexes when we load the data and usually this loading would be through a batch process.
your's seem to be an oltp system so u cannot disable the indexes.
so look into a proper design.
and first make sure that, having too many indexes is causing your problem,

Previous Topic: Unable to drop user
Next Topic: How to start database in archive log mode?
Goto Forum:
  


Current Time: Fri Sep 20 15:28:44 CDT 2024