Performance issue [message #295090] |
Mon, 21 January 2008 05:29 |
ruchika.wadhwa
Messages: 2 Registered: January 2008 Location: Noida
|
Junior Member |
|
|
I have to retrieve 100 rows with multiple columns on my screen which are fetched by stored procedure. The columns are dynamically formed. I want to tune the procedure as it is taking lot of time. few columns of a row are inserted first. Remaining columns of that row are updated on by one through "execute immediate". But as it is done for every column X no. of rows, it is taking a lot of time. Any suggestions??
|
|
|
|
|
Re: Performance issue [message #295097 is a reply to message #295093] |
Mon, 21 January 2008 05:51 |
ruchika.wadhwa
Messages: 2 Registered: January 2008 Location: Noida
|
Junior Member |
|
|
I was thinking to use it but its not feasible. Problem is we have to update or insert entire row in bulk commands. In my case, few columns are inserted first and the rmaining columns of the row are inserted by updation which is done for every remaining column. I am not able to use a pl/sql table coz i dont know how many columns will be inserted first and how many updated for that row later..
|
|
|
|
|
|
|
|