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 |
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
Can we rollback truncate?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Does sql view stored data?
what is a composite primary key ? : Sql dba
What does trigger mean in psychology?
hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?
how can we optimize or increase the speed of a mysql select query? : Sql dba
wht is the difference between sqlaserver2000 and 2005
How do you know if a relationship is 2nf?
Mention what are the benefits of pl/sql packages?
What is a primary key example?
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)