#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    2
    Rep Power
    0

    query optimizing


    how can i get this query to be optimized as its taking time to execute

    delete from table1 where (NEWS_LETTER_ID in
    ("FLOWERS","BOUQUETS") or NEWS_LETTER_ID like
    'newsletter%' ) and (REGISTERED_ID=(select from IDTABLE where ID='key1'))
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,204
    Rep Power
    4279
    the subselect looks quite wrong -- what column are you selecting?

    rudy
    http://r937.com/

IMN logo majestic logo threadwatch logo seochat tools logo