[askdba] Update

  • From: VuCanDo <vuquyen@xxxxxxxxx>
  • To: ASKDBA <askdba@xxxxxxxxxxxxx>
  • Date: Mon, 18 Oct 2004 11:27:54 -0700

Is this the right syntax or there is a better way to update this.  
It's taking forever to update this table and there are only 45, 000
rows in spy_panda_model_score

update spy_panda_all_scores a
set (rank_90_flat_period_1, rank_90_ref_period_1, paid_period_1) = 
(select flat_90_rank, ref_90_rank, paid_total from
spy_panda_model_score m where m.prov_id = a.suspect_id and
m.score_period = '2003');



Other related posts: