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 are temporal data types in oracle?
How to connect the oracle server as sysdba?
What are the numeric comparison operations?
How can you merge two tables in oracle?
What is rich query?
What is a static data dictionary in oracle?
What happens to the current transaction if a ddl statement is executed?
How can Oracle users be audited?
Can you assign multiple query result rows to a variable?
What are a cluster and non-cluster index?
What is the difference between postgresql and oracle?
Explain a segment?
Explain rename?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to recover a dropped table in oracle?