By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Deleting rows - what's most efficient?

P: n/a
In Oracle, the most efficient way to delete a row (if using a cursor
in SQL PL) is by rowid. Rowid is an internal unique identifier that
Oracle assigns to every row in a database. So you would open your
cursor by selecting rowid for the rows that you want to delete, then
do the delete by rowid.

Is there an equivalent to rowid in UDB for LUW? If not, what's the
most efficient way to delete a row? We're looking at multi-million
row purges, so I want to make sure I get this right.

Thanks.
Dec 12 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.