Interested to Buy Any Domain ? << Click Here >> for more details...
Indexes in oracle ?
- 3 Answers
- 10503 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 define an oracle sub procedure?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to get a list of all background sessions in the database?
what r routers?
What do you mean by merge in oracle?
What is archive log in Oracle?
what is main def between plsql/table and array?
what is grid in Oracle 10g...
What is the minimum client footprint required to connect c# to an oracle database?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
Explain how are indexes update?
Oracle General 
