What is the fastest way of accessing a row in a table

  • Interview Candidate
  • 2
  • 7648

Editorial / Best Answer

Indu  

  • Member Since Sep-2005 | Sep 15th, 2005

Quote

 

A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the fastest way to access any row. The ROWID contains 3 bits of information, they are :-

  1. The block within the database file.
  2. Row # within the block.
  3. Database file ID.

An example could be :-

000088C9.0191.0002

 

The ROWID has three important uses, it is :-

  1. The fastest path to any row.
  2. A way of speeding the COMMIT process in application code.
  3. Unique identifiers of any given row.

Unquote

 

Showing Answers 1 - 2 of 2 Answers

Sajida

  • Jun 10th, 2005
 

By using rowid

  Was this answer useful?  Yes

Indu

  • Sep 15th, 2005
 

Quote

 

A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the fastest way to access any row. The ROWID contains 3 bits of information, they are :-

  1. The block within the database file.
  2. Row # within the block.
  3. Database file ID.

An example could be :-

000088C9.0191.0002

 

The ROWID has three important uses, it is :-

  1. The fastest path to any row.
  2. A way of speeding the COMMIT process in application code.
  3. Unique identifiers of any given row.

Unquote

 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions