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 a primary key sql?
If a View on a single base table is manipulated will the changes be reflected on the base table?
How do you declare a variable in pl sql?
how to retrieve the top 3 salaries of the table using rownum
what is cursor. write example of it. What are the attributes of cursor.
What is the difference between the implicit and explicit cursors?
what are the properties and different types of sub-queries? : Sql dba
What is normalisation in sql?
what is column? : Sql dba
What are the differences between implicit and explicit cursors?
What is parameter substitution in sql?
How is indexing done in search engines?
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)