PL/SQL (MOSC)

MOSC Banner

Performance of a insert degrades when populating a column.

in PL/SQL (MOSC) 2 commentsAnswered

Hi,

I am inserting data into a table from a view. Till date data the performance has been good. A new column had been added to the view. When I try to populate data of this new column to the corresponding column in the table, the program runs for very long time. What could be the issue ?


The view fetches the data in a reasonable time.

Thank you in advance.


Thanks,

Krishna

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center