Answer / anupam bhatt

SQL optimization or tuning is the process to improve upon your sql queries to make them more efficient and avoid common pitfalls like multiple database round trips etc. Basically do more work with fewer queries to make the application fast and manageable.

This can be achieved by various ways like joining multiple queries in to one to avoid multiple network round trips, add indexes to the tables which are frequently accessed to reduce the turnaround time, fetch only the required data instead of a generic query getting all of the data of the table etc.

how to write date and time literals? : Sql dba

0 Answers  

---

What is memory optimized table?

0 Answers  

---

How do I remove sql plus from windows 10?

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

How do I view tables in sql developer?

0 Answers  

---

What is rtm stands for?

0 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

What is replication id?

0 Answers  

---

What is a constraint?

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---