Interested to Buy Any Domain ? << Click Here >> for more details...
Indexes in oracle ?
- 3 Answers
- 10533 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 |
Give the different types of rollback segments.
Can we convert a date to char in oracle and if so, what would be the syntax?
What a SELECT FOR UPDATE cursor represent.?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
How to rename a tablespace in oracle?
Explain the types of exception?
How to start a new transaction in oracle?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What are dml statements in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How to write a query with a left outer join in oracle?
what are the disadvantages of hierarchial database over RDBMS?
Oracle General 
