| ROWID location [message #51315] |
Wed, 15 May 2002 08:01  |
Thomas P Mathew
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
|
Thanx & rgds in advance for anybody who can enlighten me on the following:- We all know that ROWIDs are stored as part of the index entry, and also that it is not a part of the table. Say, I have a table with out an index and I give 'SELECT col1,COL2,ROWID FROM table ... . My question now is, where this rowid is coming from / where it is stored, if not in the table ?
|
|
|
|
| Re: ROWID location [message #51319 is a reply to message #51315] |
Wed, 15 May 2002 09:21  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
rowid's are not stored in indexes as if that is their home. the index uses the rowid to point to the exact physical location of the row.
rowid's are oracle's identifiers for rows, and are, i believe, stored in the block header. the rowid is a composite of file, block, and a third item that together make the id.
when you query a table and include 'rowid' in the column list, you are asking oracle for what they call pseudo-column that returns rowids.
you do not have to have an index for the rowid to exist.
|
|
|
|
| Re: ROWID location [message #51330 is a reply to message #51315] |
Wed, 15 May 2002 22:46 |
sharma
Messages: 10
Registered: February 2002
|
Junior Member |
|
|
rowid will in stored in the table only. in addition ,if you have any index on any table then it will make an entry into the index table with the index column value.
cheers
h.b. sharma
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
