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 |
What is the difference between alert log file and trace file ?
What privilege is needed for a user to create indexes in oracle?
How to find no of saturdays in a month using single sql ?
How to change program global area (pga) in oracle?
Without giving condition how to retrieve the unmatched records from table.
How to export several tables together?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
ABOUT IDENTITY?
How to invoke the data pump import utility?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
What is meant by redo log buffer ?
How to use "in out" parameter properly?