What is the fastest way of accessing a row in a table?
- 5 Answers
- 18493 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 |
What is the difference between cluster and non-cluster index?
What is sql stand for?
How to use boolean type in select statement?
What is trigger in pl sql?
What is the maximum size of sqlite database?
How would you pass hints to the sql processor?
What is orm in sql?
Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.
what is sql optimization
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
how to rename an existing column in a table? : Sql dba
What sql database should I use?
-
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)
