What is the fastest way of accessing a row in a table?




Answers were Sorted based on User's Feedback



What is the fastest way of accessing a row in a table?..

Answer / ritesh

The fastest way to acces row is by rowid.

Is This Answer Correct ?    33 Yes 2 No

What is the fastest way of accessing a row in a table?..

Answer / rohit

By making index of that row.

Is This Answer Correct ?    14 Yes 7 No

What is the fastest way of accessing a row in a table?..

Answer / vidit tyagi

The fastest way to acces row is by rowid.

Is This Answer Correct ?    7 Yes 2 No




What is the fastest way of accessing a row in a table?..

Answer / maheshg

It's Rowid is the fastest way to access the row.

Is This Answer Correct ?    0 Yes 0 No

What is the fastest way of accessing a row in a table?..

Answer / bhisma

The Fastest way to access a row is to use primary key of
the table.

Is This Answer Correct ?    0 Yes 6 No

Post New Answer



More SQL PLSQL Interview Questions

What is pseudo column ?

6 Answers   ABB,


please explain database architecture..

1 Answers   Infosys,


Query for second maximum salary in each in each department

15 Answers   TCS, DST Global Solutions,


what are the forced views

6 Answers   TCS, Hexaware,


What are different types of joins ?

5 Answers   BirlaSoft,






What are the datatypes a available in PL/SQL ?

2 Answers  


how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

7 Answers  


what is the forward decleration in packages?

1 Answers  


How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   KCP, Fidelity,


what is global table

7 Answers   iFlex,


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,


how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,






Categories