Re: [SQL] More efficient DELETE ... ?

> 
> This looks painful ...
> 
> DELETE FROM webhit_referer_raw
>       WHERE oid IN ( SELECT w.oid
>                        FROM webhit_referer_raw w, referrer_data r
>                       WHERE stat_date < 'Jan 17 2000 15:05:00'
>                         AND w.referrer_url = r.referrer );
> 
> But, reading through the man page, it looks like this about the only way
> of doing it?  Or am I missing something as obvious as the UPDATE I asked
> about the other day? :(

Read chapter 8 from my book.  That is the only way for DELETE.  You
could to EXISTS and that may be faster.


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026