How does rowid help in running a query faster?



How does rowid help in running a query faster?..

Answer / Charanjeet Singh

RowIDs are unique identifiers assigned to each row in a table. By using the RowID, you can perform fast lookups and access individual rows quickly, as the database does not have to scan the entire table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between union and union all? : Sql dba

1 Answers  


Can you inner join the same table?

1 Answers  


What is the difference between left outer join and left join?

1 Answers  


List the different type of joins?

1 Answers  


Explain the commit statement.

1 Answers  


What are the usages of sql?

1 Answers  


What is use of term?

1 Answers  


how are mysql timestamps seen to a user? : Sql dba

1 Answers  


How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,


How many types of triggers exist in pl/sql?

1 Answers  


What are different types of keys?

1 Answers  


Why do we use procedures?

1 Answers  


Categories