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 |
Differentiate between pre-select and pre-query?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Do View contain Data ?
What is a named program unit?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Can a field be used in a report without it appearing in any data group ?
How to use in conditions in oracle?
What is an oracle and why it is used?
What is the sql query to concatenate column values from multiple rows in oracle?
How to retrieve the count of updated rows?
Explain a synonym?
What is SQL Tuning Advisor in Oracle?