what are indexes..how many types of index's are there and
what are they?
Answer Posted / test
Index simply means sorting of data. Let u stake an example :
EmpID Name
1 A
6 B
5 C
9 D
...
...
2 ZZ
Now if we create index (Talking about btree index) on EmpId
it means creating a segment with the following in sorted
order
EmpId Rowid
1 <some value>
2 ....
5 ...
6 ...
...
Now if we want to search with EmpId, it will do a binary
search and get the rowid in few searches
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is data file?
What happens if you use a wrong connect identifier?
What is a table index?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to change system global area (sga) in oracle?
What the is the diff between local index and global index. give some example.
What is a server parameter file in oracle?
What to do if dba lost the system password?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Explain implicit cursor.
Can we write insert statement in function in oracle?
What is partitioned table in Oracle?
Explain oracle insert into command?