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


Please Help Members By Posting Answers For Below Questions

What do database buffers contain?

784


What are the logical operations?

905


Does oracle charge for java?

839


How to change user password in oracle?

839


Explain the use of full option in exp command.

788


Why do we use bulk collect in oracle?

830


How to check the server version in oracle?

847


What is the data type of dual table?

716


Explain what are the characteristics of data files?

842


How to drop an existing view in oracle?

764


How does one get the view definition of fixed views/tables?

817


Explain cascading triggers.

828


What are the execution control statements?

841


What is difference between sid and service name in oracle?

724


Explain the use of online redo log files in oracle.

802