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 to do if dba lost the system password?
How to use select statement to count the number of rows in oracle?
What is bulk load in oracle?
What are the differences between lov and list item?
What would you do with an in-doubt distributed transaction?
Why do we need integrity constraints in a database?
What are a collation and state the different types of collation sensitivity?
What is sharded cluster?
What is an Oracle Instance?
What are the predefined tablespaces in a database?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
State all possible different index configurations a table can possibly have?
How to define an anonymous procedure without variables?
How to define a sub function?
How to select some columns from a table in oracle?