Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Different ways to improve Insert Query

ArtiBhat
Associate
Associate

‎06-29-2007 7:05 AM

0 Kudos

Hi All,

I want to improve the performance of SQL query

"INSERT (REF_TABLE_NAME) FROM TABLE INSERT_TAB." as it is taking v.long time to execute.

Would request you to suggest some best ways to do it ASAP.

Best Regards,

Arti.

4 REPLIES 4

Former Member

‎06-29-2007 10:36 AM

0 Kudos

Hi Arti,

I am really unable to make out, Can you please mail the code to me

Former Member

‎06-29-2007 10:40 AM

0 Kudos

Hi,

Enque and deque the table and inb/n do this.

use roll back work and commit work

and if the datat is very high then its better to do by fixed number.

Regards,

sasi

ArtiBhat
Associate
Associate
In response to Former Member

‎07-03-2007 7:49 AM

0 Kudos

Hi,

Thanks for your help.

Can you please explain in detail how it is going to improve the performance.

Regards,

Arti.

Former Member
In response to Former Member

‎07-03-2007 2:29 PM

0 Kudos

I think there's not much you can do to improve performance. The only possibility (and it's a slim one) that I can think of, would be to insert into a specific table rather than one defined at run time.

Rob