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 global variable in pl/sql
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
What is Pragma EXECPTION_INIT ? Explain the usage ?
how can we find the select statement is indexed or not?
what is difference between procedure and function, procedure and trigger?
Is and as keyword in pl sql?
What is difference between sql and excel?
Does group by remove duplicates?
What are the two types of periodical indexes?
How delete all data from all tables in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
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)