Using the WITH ROWIDS Option

Nonfragmented tables contain a hidden column called rowid, but by default, fragmented tables have no rowid column. You can use the WITH ROWIDS keywords to add the rowid column to a fragmented table. Each row is automatically assigned a unique rowid value that remains stable for the life of the row and that the database server can use to find the physical location of the row. Each row requires an additional four bytes to store the rowid.

This is a deprecated feature. The query optimizer might not use an index scan when explicit rowid shadow columns are defined on fragmented tables. When creating new applications, use primary keys as a method of row identification instead of using rowid values.

You cannot use the WITH ROWIDS clause with typed tables.

Copyright© 2019 HCL Technologies Limited