1.

How Rowids Are Used?

Answer»

Oracle uses ROWIDs internally for the CONSTRUCTION of indexes. Each key in an index is associated with a ROWID that points to the associated row’s address for fast access.End–users and application developers can also USE ROWIDs for SEVERAL important uses:

  • ROWIDs are the fastest means of accessing particular rows.
  • ROWIDs can be used to see how a table is organized.
  • ROWIDs are UNIQUE identifiers for rows in a given table.

Oracle uses ROWIDs internally for the construction of indexes. Each key in an index is associated with a ROWID that points to the associated row’s address for fast access.End–users and application developers can also use ROWIDs for several important uses:


Discussion

No Comment Found

Related InterviewSolutions