113 reputation
2
bio website
location
age
visits member for 1 year, 6 months
seen Oct 30 '13 at 12:57

Oct
24
awarded  Student
Oct
24
awarded  Scholar
Oct
24
comment oracle merge operation hangs (or loops); query tuner claims it's a cartesian product operation
Yep, that looked to be what it was. I stuck an alter index ... unusable before truncating and inserting, then a alter index ... rebuild after, followed by a dbms_stats.gather_table_stats(). Maybe a little ham-fisted, but it's running smoothly now. Thanks!
Oct
24
accepted oracle merge operation hangs (or loops); query tuner claims it's a cartesian product operation
Oct
24
comment oracle merge operation hangs (or loops); query tuner claims it's a cartesian product operation
hmm. Well, this is a fairly new table, and the gets populated during the first run. Would it make sense to do the initial insert (fill) then update the statistics, before continuing with the merge(s)? We're only dealing with about 8.5k in the details and and about 5.6k that would be eligible for matching.
Oct
24
asked oracle merge operation hangs (or loops); query tuner claims it's a cartesian product operation