RE: Delete query...question.

any ways when u use order by clause it will surely slow down.....

rgds,
Ams.

-----Original Message-----
Chris
Sent: Wednesday, July 10, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L

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" <ORACLE-L_at_fatcity.com> 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: steven.hovington_at_procession.com
>
> 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: ListGuru_at_fatcity.com (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: big_planet_2000_at_hotmail.com

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: ListGuru_at_fatcity.com (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: cgrabowy_at_fcg.com

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: ListGuru_at_fatcity.com (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: Amjad
  INET: amjad_at_medicomsoft.com

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: ListGuru_at_fatcity.com (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).