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
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
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
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
can u give guidance abt packages of plsql
What is Restricted Mode of Instance Startup in Oracle?
Where in the Oracle directory tree structure are audit traces placed?
What Are Cross Validation & Adi?
What is chargeback invoice? How do we create it? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What do you mean by hz_ in customer tables? : oracle accounts receivable
key flexfield structure
what is semphore explian it?
