Give the reasoning behind using an index.
- 2 Answers
- 5313 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
whats the difference between join command and Cartesian product using example?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Where in the Oracle directory tree structure are audit traces placed?
How can you rebuild an index?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Explain the process of recievables in oracle financials. : oracle accounts receivable
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
What view would you use to look at the size of a data file?
What is chargeback invoice? How do we create it? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Oracle General 
