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

Answer Posted / maheshg

It's Rowid is the fastest way to access the row.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between a local and a global temporary table? : Sql dba

562


What are the 3 modes of parameter?

692


What is user in sql?

594


what is a stored procedure? : Sql dba

569


What is materialized view. What are different methods of refresh?

796






What are aggregate and scalar functions?

536


Can a key be both primary and foreign?

517


What is a function in oracle pl sql?

551


How do I view an execution plan in sql?

541


Is sqlite good enough for production?

552


What is 19 null in sql?

547


Which one is better sql or oracle?

508


How much does a sql dba make? : SQL DBA

524


Can we join tables without foreign key?

530


explain advantages of myisam over innodb? : Sql dba

615