Indexes in oracle ?
- 3 Answers
- 8712 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 |
what's query optimization and without use of IN AND Exist can we get another way data from query
Why do you use stored procedures and state some of its disadvantages?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is ordinary table in oracle?
What are oracle functions?
Which are the five query types available in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain an extent?
Which is better Oracle or MS SQL? Why?
What is an oracle database table?
What is SAVE POINT ?
Oracle General 
