
178 7.1 Basic Query Tuning
Note: Then again, accessing rows using ROWIDs can be leaps and bounds
faster than any other access method. Static data or read-only data ware-
houses are most certainly a possibility. Be aware of anything that might
cause changes to ROWID values—namely, anything making up the
ROWID, such as tablespace or datafile. I have experimented with ROW-
IDs. Once again, it is not a recommended practice, so I can’t be held
responsible if your implementation goes completely nuts. I would suggest
experimenting with purely static databases. And the operative term is I
think database-wide, not tablespace–wide, or even table-wide, but an entire ...