SQL Performance (MOSC)

MOSC Banner

How oracle internal reverse search index object.

edited Aug 6, 2015 10:00AM in SQL Performance (MOSC) 11 commentsAnswered

How oracle can quickly to allocate a entry in index when user to delete a record in main table use rowid?

For a sample, we have a big table with million rows, each row have same value for column called Status, also have index on column Status. When delete a row using rowid, such delete statement can be executed very quick, it does not like oracle to scan full index to allocate the rowid value in index.

Oracle must have a efficient method to quickly allocate the corresponding entry in index, then mark this entry as deleted. Anyone know how Oracle internally handle such reverse search?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center