What is the fastest way of accessing a row in a table?
- 5 Answers
- 18499 Views
- TCS, I also Faced
- E-Mail Answers
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 |
In pl/sql, what is bulk binding, and when/how would it help performance?
What is the main reason behind using an index?
what is meant by urlencode and urldocode? : Sql dba
How to maintain the history of code changes of pl/sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What does data normalization mean?
What are secondary keys?
How long does it take to learn pl sql?
What is difference between sql and mysql?
What is difference between left and right outer join?
what are the types of join and explain each? : Sql dba
how is myisam table stored? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
