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
- 31142 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
Explain the types of exception?
what are the default admin accounts in Oracle 10g ?
How much memory your 10g xe server is using?
Explain oracle data types with examples?
What is a table in oracle?
How to do paging with oracle?
What is an oracle database?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is redo log?
What is a snapshot in oracle database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to use regular expression in pattern match conditions in oracle?
How can you merge two tables in oracle?
What do you understand by a database object?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
