I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

Why is sql*loader direct path so fast?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

what are myisam tables? : Sql dba

0 Answers  

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

What are the built in functions of sql?

0 Answers  

---

What are crud methods?

0 Answers  

---

What is an exception in pl/sql?

0 Answers  

---

How to write html code in pl sql?

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---