What is the difference between implicit index and explicit
index?
- 2 Answers
- 22710 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
What is a Redo Log ?
which language is used to develop the oracle........?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain a synonym?
What is difference between cartesian join and cross join?
How to resolve name conflicts between variables and columns?
definition of cluster and non-clustered index?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
How do we get field details of a table?
query optmization techniques and quwry analyser+projects+ppts
What are the restrictions on external table columns?
Oracle General 
