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 rename in sql?

548


Can we use ddl statements in stored procedure sql server?

517


Why plvtab is considered as the easiest way to access the pl/sql table?

617


Can we use the cursor's to create the collection in PL/SQL?

518


What is procedure and function?

515






Whis is not false in primary key?

975


Describe different types of general function used in sql?

530


What is the use of desc in sql?

494


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

593


How do you write an inner join query?

511


How do you clear the screen in sql?

599


How many databases can sql express handle?

532


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

498


How many tables can you join in sql?

528


What are the indexing methods?

571