Indexes in oracle ?
- 3 Answers
- 9449 Views
- Keane India Ltd, L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramprasad.s
Hi
Indexes in oracle are to retrieve the data from the
database at a faster rate
bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / basanti
Hello
Index is a database object which is use to access data
faster its like content page in a book
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radha
Indexes in Oracle are:
(create <type of index> index <indexname> on <tablename>
(<colname>)
1. B-Tree (regular indexing algorithm )
2. Bitmap (for low cardinality fields.
By default oracle creates bitmap Index)
3. Partitioned indexes (for manageability
and to distribute I/O evenly)
4. Function based indexes (when you want
to index a function based calculation itself)
5. IOTs (Index organised tables - Table and
Index combined into one)
6. Domain Indexes (using user defined index types)
| Is This Answer Correct ? | 0 Yes | 2 No |
 How to use an oracle sequence generator in a mapping?
Point the difference between translate and replace?
how to find count rows in table without count function?
How to restrict the duplicate records in table valuesets
Explain cascading triggers.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What is oracle used for?
How to get a list of all user accounts in the database?
Explain the use of file option in exp command.
What is an Index ?
Give the advantages and disadvantages of clusters.
Oracle General 
