Answer / Ishank Awasthi

Optimizing SQL queries involves several steps such as indexing, reducing joins, minimizing subqueries, and using the appropriate data types. Also, consider breaking large queries into smaller pieces (chunking), and utilizing EXPLAIN PLAN to better understand how the query is executed.

How do you write an inner join query?

1 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

1 Answers  

---

What is data manipulation language?

1 Answers  

---

Which join is like an inner join?

1 Answers  

---

What is sql used for?

1 Answers  

---

How do you drop a trigger?

1 Answers  

---

What is minus?

1 Answers  

---

Is join and inner join the same?

1 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

Explain the significance of the & and && operators in pl sql.

1 Answers  

---