What is indexing, and how does it improve performance?

1 Answers  

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

0 Answers   Intelligroup,

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

Does oracle partitioning improve performance?

0 Answers  

---

Difference between oracle's plus (+) notation and ansi join notation?

0 Answers  

---

DBMS vs. RDBMS

2 Answers   TCS,

---

How to display First 4 rows From Database Table?

6 Answers  

---

what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,

---

How to write a query with a right outer join in oracle?

0 Answers  

---