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

Answer Posted / rohit

By making index of that row.

Is This Answer Correct ?    14 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to process query result in pl/sql?

773


What is the difference between pl and sql?

735


What is $$ in sql?

728


Why is sql*loader direct path so fast?

797


What does rownum mean in sql?

722






What is hibernate and its relation to sql?

787


Can we connect to postgresql using sql developer?

697


what is the use of set statement in tsql? : Transact sql

739


Show how functions and procedures are called in a pl/sql block.

766


How does sql*loader handles newline characters in a record? : aql loader

763


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3579


what is the use of friend function? : Sql dba

726


Why do we use procedures in pl sql?

720


What is AUTH_ID and AUTH_USER in pl/sql ?

1936


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

701