it did..  thanks.. generally a weeks process turned out to be less than a 

On Thursday 25 November 2004 15:06, Christopher Kings-Lynne wrote:
> >             update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in 
> > (select
> > mobile_num from LOADED_MOBILE_NUMBERS)
> Change to:
> update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where exists (select 1 from
> lmn.mobile_num=SUBSCRIPTIONTABLE.mobile_num);
> That should run a lot faster.
> Make sure you have indexes on both mobile_num columns.
> Chris
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?


Jerome Macaranas
Systems/Network Administrator
GMA New Media, Inc.
Phone: (632) 9254627 loc 202
Fax: (632) 9284553
Mobile: (632) 918-9336819

Sanity is the playground for the unimaginative.

DISCLAIMER: This Message may contain confidential information intended only 
for the use of the addressee named above. If you are not the intended 
recipient of this message you are hereby notified that any use, 
dissemination, distribution or reproduction of this message is prohibited. If 
you received this message in error please notify your Mail Administrator and 
delete this message immediately. Any views expressed in this message are 
those of the individual sender and may not necessarily reflect the views of 
GMA New Media, Inc.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to