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 form and report?
Write a procedure to return the month and the number of developers joined in each month (cursor )
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How do I run sql profiler?
Can you alter start with clause?
What is an alias command?
What is the difference between rollback and rollback to statements?
How does stored procedure reduce network traffic?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
What is dense_rank in sql?
How to select unique records from a table?
What is the command used to fetch first 5 characters of the string?
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)