Hi to all,
I've a problem, i must execute a tansposition of a Table to an another table, in Oracle.
I ve 1 million record to read and next to do a insert of a selection of record input.
The procedure that i have done it's slow, so i want to speedup it.
How can I do?
the first table have
code
value
col_name
order
the second have a 200 column with the name "col_name".
I've a Index (code,order).
How can increase the size of memory block? and the Cache
I've a problem, i must execute a tansposition of a Table to an another table, in Oracle.
I ve 1 million record to read and next to do a insert of a selection of record input.
The procedure that i have done it's slow, so i want to speedup it.
How can I do?
the first table have
code
value
col_name
order
the second have a 200 column with the name "col_name".
I've a Index (code,order).
How can increase the size of memory block? and the Cache