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
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
HOW TO SPOT AHIERARCHY?
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?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What is supporting issues GL AP and AR?
What is Tax Categories?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Differentiate between transaction type and transaction source? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
Explain the payment term in ar. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
