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
- 31492 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 store only time; not date and time?
What is oracle database client?
how to do daily transactions with out sql* loader control file regesterd in apps?
Compare and contrast between sql and sql server and explain its various functions?
What types of joins are used in writing subqueries?
How to speed up webrick?
What are the data types in oracle?
What do you mean by a deadlock?
What is a subquery in oracle?
How to list all indexes in your schema?
How to insert a record into a table?
List the types of joins used in writing subqueries?
How to start a new transaction in oracle?
What is data block in Oracle?
What are the varoius components of physical database structure of oracle database?
