What is the difference between implicit index and explicit
index?
Answers were Sorted based on User's Feedback
Answer / 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 |
How to create a new view in oracle?
What privilege is needed for a user to create indexes in oracle?
What is an oracle cursor variable?
When system tablespace is created?
what is the syntax of UPDATE command?
What is the difference between pre-select and pre-query?
What is an UTL_FILE.What are different procedures and functions associated with it?
How to put more than 1000 values into an oracle in clause?
Difference between cartesian join and cross join?
What are the major difference between truncate and delete?
Is oracle a relational database?
Which environment variables are absolutely critical in order to run the OUI?