What is the difference between implicit index and explicit
index?
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
What is the difference between pre-select and pre-query?
What to do if dba lost the system password?
Give the different types of rollback segments.
How can we delete duplicate rows in a table?
What is oracle open database communication (odbc)?
How to insert a record into a table?
Difference between pre-select and pre-query
What is archive log in Oracle?
How to rename an index?
What are the data types in oracle?
What is pragma autonomous transaction in oracle?
How to view the tablespaces in the current database?
How to see free space of each tablespace?
What are the different types of trigger and explain its various uses and functions?
What is the purpose of tables, private synonyms and public synonyms in Oracle?