Different ways to improve Insert Query

[ArtiBhat]

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.

[ArtiBhat]

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.

[Former Member]

Hi Arti,

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

[Former Member]

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]

Hi,

Thanks for your help.

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

Regards,

Arti.

[Former Member]

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