Answer Posted / 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.

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1003

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2413

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2058

---

what are basic modules required to implement oracle application in any oraganisation?

2144

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2095

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2048

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2163

---

What Are Cross Validation & Adi?

1095

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4385

---

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

1174

---

1. What is PO rate variance gain and loss?

2831

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1100

---

What is an Oracle database Partial Backup?

1106

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2470

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2428

---