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
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the disk migration? what is the steps involved in oracle disk migration?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
default triggers available for reports
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What is the sql query to find the employee who has Nth maximum salary?
What is the use of lockboxes? : oracle accounts receivable
