How many different types of indexes we have in oracle?
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 Oracle table?
Write a syntax for update query in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What do you know about normalization? Explain in detail?
select statement does not retrieve any records. what exception is raised?
How can you merge two tables in oracle?
What is the fastest query method to fetch data from the table?
Define 'view' advantage ?
What a SELECT FOR UPDATE cursor represent.?
What privilege is needed for a user to delete rows from tables in another schema?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
How do I manually create a database in oracle?