Interested to Buy Any Domain ? << Click Here >> for more details...
Indexes in oracle ?
- 3 Answers
- 10297 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 |
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What are the different types of databases?
What is coalesce function?
What do you understand by a database object? Can you list a few of them?
What is OCI. What are its uses?
What is the use of Redo Log Information ?
where we have to use ON clause and where we have to use USING clause in JOINS
How do I manually uninstall oracle client?
What are the predefined tablespaces in a database?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
What is different types of joins?
What is bulk load in oracle?
Oracle General 
