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 is an oracle function?

595


Explain user account with reference to oracle.

527


How to get last row id?

553


What are the types of trigger in oracle?

573


How does oracle handle read consistency?

674






how may join possible between (requisition with purchase order)

1695


What is oracle latest version?

577


How to define a data source name (dsn) in odbc manager?

525


Is primary key indexed by default in oracle?

540


What is key preserved table?

558


Explain what are the type of synonyms?

578


can u plz provide me oca sql dumps please i need them

1466


What are the differences between lov and list item?

559


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1792


How to load data through external tables?

581