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 |
Can u make a synonym for deptno=10 only from emp table.
what is the use of composite key constraint?
How to connect to a remote server?
How to list all user accounts in oracle?
Can we create more than one constraint to column ?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
Is oracle an operator?
Explain the use of record length option in exp command.
what is the output of select * from emp where null=null & select * from emp where 1=1
Difference between cartesian join and cross join?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to write a query with a left outer join in oracle?