Sequence taking more time
I am inserting 200000 records into a table test1 and test2 , both are having same structure and test2 is having 1 extra sequence column.
Now while loading test1 is taking 10 sec while test2 is taking 1 hr.
What could be the reason ?
Why sequence creation is taking so much time ?