topic Re: Different ways to improve Insert Query in Application Development and Automation Discussions

Different ways to improve Insert Query

ArtiBhat — Fri, 29 Jun 2007 06:05:24 GMT

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.

Re: Different ways to improve Insert Query

Former Member — Fri, 29 Jun 2007 09:36:21 GMT

Hi Arti,

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

Re: Different ways to improve Insert Query

Former Member — Fri, 29 Jun 2007 09:40:20 GMT

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

Re: Different ways to improve Insert Query

ArtiBhat — Tue, 03 Jul 2007 06:49:55 GMT

Hi,

Thanks for your help.

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

Regards,

Arti.

Re: Different ways to improve Insert Query

Former Member — Tue, 03 Jul 2007 13:29:51 GMT

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