What is the difference between implicit index and explicit
index?
- 2 Answers
- 23447 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / daid kuamr
Implicite index is created by oracle Internally
ex: when we make a primary key in a Column then implicit
Index created which is Clustered Type index(Default)
while Explicite index created by "Create Index Command'
User
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
Is there an oracle sql query that aggregates multiple rows into one row?
How to recover a dropped table in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How to use null as conditions in oracle?
What is the difference between a hot backup and a cold backup in oracle?
What is a proxy class?
How to use "if" statements on multiple conditions?
What do you mean by cdb and pdb in oracle 12c?
What privilege is needed for a user to delete rows from tables in another schema?
What are the parameters that we can pass through a stored procedure?
How to create an oracle database manually?
What are the uses of a database trigger?
How to delete a column in an existing table?
How can I see all tables in oracle?
Explain what are the uses of rollback segment?
