Q
Manage Learn to apply best practices and optimize your operations.

How to improve insert performance

How can I improve performance for an insert in SQL? The insert is being done into a table from more than one session, one from a VB front end and the other from a Unix back end. The table has three indexes and many constraints.

How can I improve performance for an insert in SQL? The insert is being done into a table from more than one session, one from a VB front end and the other from a Unix back end. The table has three indexes and many constraints.
First, trace your insert session and see how time is being spent. One common problem with inserts is SQL that uses literal values rather than bind variables, meaning that instead of one SQL statement that can be reused, you have many SQL statements that are each parsed once. If you see many SQL statements in your trace file that differ only in their literal values, change your application to use a single statement that is bound to different values each time it's executed.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close