Interested to Buy Any Domain ? << Click Here >> for more details...
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you determine what sessions are connected and what resources they are waiting for?
What is the difference between recovery and restoring of the oracle database?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
please send me oracle pl/sql exp resume. and also faqs...
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Difference between transaction type and transaction sources. : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
which one is currently in used software cmpanies.
What is the use of lockboxes? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
