Interested to Buy Any Domain ? << Click Here >> for more details...
what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 31753 Views
- Green Info Solutions, TCS, I also Faced
- E-Mail Answers
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
How to use null as conditions in oracle?
What is index in Oracle?
How can I create database in oracle?
How to drop a stored procedure in oracle?
What do you mean by a tablespace?
How to store only time; not date and time?
What is an oracle tablespace?
What would you do with an in-doubt distributed transaction?
How to use "in out" parameter properly?
How to insert a new row into a table in oracle?
Explain oracle left join with an example?
What is Redo Log Buffer in Oracle?
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??
How to get execution statistics reports on query statements?
please explain.. DB architecture ...
