Interested to Buy Any Domain ? << Click Here >> for more details...
Indexes in oracle ?
- 3 Answers
- 10346 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 do I connect to oracle?
what are corelated subqueries
What is a materialised view?
What is a user account in oracle?
How would you optimize a slow SQL query?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
what is the syntax of INSERT command?
How to define an anonymous block?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
How to delete all rows a table in oracle?
Why is oracle database so popular?
Oracle General 
