What is the fastest way of accessing a row in a table?
Answers were Sorted based on User's Feedback
Answer / maheshg
It's Rowid is the fastest way to access the row.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bhisma
The Fastest way to access a row is to use primary key of
the table.
| Is This Answer Correct ? | 0 Yes | 7 No |
What is dbo in sql?
Is primary key always clustered index?
What are the sql aggregate functions?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
What is error ora-01000: maximum open cursors exceeded
What are the blocks in stored procedure?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
What is difference between sql function and stored procedure?
What are the advantages of indexing?
Can we insert data into view?
What are the different schemas objects that can be created using pl/sql?
What is package in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)