Answer / pradeeshkumar

Its as simple as why do we need an index page in front of a
book. Whenever we wish to read a scpecific text from the
book, we'll first check the index and locate where that
specific text is. Similarly when create an index it enables
the queries to locate praticular row or entity in a table
by directly refering to the index instead of searching the
entire table. Whenever a table is created with a primary
key, an index ia automatically created on the primary key
column which makes easier access of table entries. When you
execute query say( select * from student where
student_id=10;), your query will first hit the index
(primary index on primary key column) and then will retrive
the corresponding row from the table. If there's no such
entry in the table, it'll return an empty result set
without searching the table.

Answer / pradeeshkumar

Its as simple as why do we need an index page in front of a
book. Whenever we wish to read a scpecific text from the
book, we'll first check the index and locate where that
specific text is. Similarly when create an index it enables
the queries to locate praticular row or entity in a table
by directly refering to the index instead of searching the
entire table. Whenever a table is created with a primary
key, an index ia automatically created on the primary key
column which makes easier access of table entries. When you
execute query say( select * from student where
student_id=10;), your query will first hit the index
(primary index on primary key column) and then will retrive
the corresponding row from the table. If there's no such
entry in the table, it'll return an empty result set
without searching the table.

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

---

What is index? How many types of indexes?

2 Answers   HCL,

---

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---

---

how to replace not in with not exist?

0 Answers   IBM,

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

0 Answers   Wipro,

---

What is the disk migration? what is the steps involved in oracle disk migration?

0 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---