Improve Insertion rate in oracle

[dilippanda]

Hi All,

I am experiencing performance issue while merging records from a select query.
Also it is getting difficult to insert 100000 selected records into table which is taking around 30 mins.

I have tested the select query which is taking around 40 sec to fetch 1Lakh records.

Is there anyway to improve the insertion rate?

Thanks,
Dilip

[debasisdas]

it all depends on the table structure of both the tables. along with number of records ,number of olumns are also important .again it can be hardware and network dependent.

[dilippanda]

Number of records are around 80000.
Both the table has around 13 columns and 3 indexes.

What should be done in such cases?

Please guide me.

Thanks,
Dilip

it all depends on the table structure of both the tables. along with number of records ,number of olumns are also important .again it can be hardware and network dependent.

[amitpatel66]

I would suggest you to use the proper INDEX from the three by using a HINT in the QUERY. THat would fasten up and improve the performance of your Query. Using wrong index will also HIT the performance very badly.