I was just wondering... Specifically, on the DELETE's WHERE clause, isn't it better to use ROWID versus CREATED??
If you use ROWID then you don't have to walk the index. DELETE FROM tbl WHERE ROWID..... If you use CREATED then you have to walk the index, again? Right? DELETE FROM tbl WHERE created.... To head off emails, I know your supposed to be very careful when working with ROWID, i.e. not storing rowid for future reference, etc. But this specific example seems to be ok. Thoughts? -----Original Message----- Sent: Tuesday, July 09, 2002 1:54 PM To: Multiple recipients of list ORACLE-L delete from tbl where rowid in ( select rowid from tbl where user_id = &user and rownum =1 order by date asc ) -bp ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 9:59 AM > Hi, > > Can anyone help me with this delete statement? > > I have the following table: > > Name Null? Type > ----------------------------------------- -------- ------------- > USER_ID NOT NULL NUMBER(15) > PASSWORD VARCHAR2(30) > CREATED DATE > > What I need to do is delete the oldest record for a particular user_id. > And its doing my head in. Any help appreciated! > > Thanks, > Steve. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Hovington > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).