Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192542 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sathish
B TREE INDEX
FUNCTION BASED INDEX
REVERSE KEY INDEX
BIT MAP INDEX
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rohit
In Oracle there are two types of SQL index namely, implicit and explicit.
Implicit Indexes:
They are created when a column is explicity defined with PRIMARY KEY, UNIQUE KEY Constraint.
Explicit Indexes:
They are created using the "create index.. " syntax.
NOTE:
1) Even though sql indexes are created to access the rows in the table quickly, they slow down DML operations like INSERT, UPDATE, DELETE on the table, because the indexes and tables both are updated along when a DML operation is performed. So use indexes only on columns which are used to search the table frequently.
2) Is is not required to create indexes on table which have less data.
3) In oracle database you can define up to sixteen (16) columns in an INDEX.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shankar
1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Hash Index?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
What is a table index in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
what are bitmap indexes? How does they work?
How many memory layers are in the oracle shared pool?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
Explain what are the different type of segments?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
Explain the importance of .pll extension in oracle?
What is a trace file and how is it created in oracle?
How do I start tns listener?
Oracle General 
