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 is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is Tax Categories?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is the difference between recovery and restoring of the oracle database?
What is auto invoicing? : oracle accounts receivable
Could you please let me know the interfaces in OM / FA??
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What do you mean by Oracle MEDIA RECOVERY?
How many segment are present in Oracle Manufacturing
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are the tools used for oracle 10g in real time.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
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?
Is there any link between pr form(purchse requisition)and po form(purchase order)
