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.

Can we use ddl commands in pl sql?

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

What is scope of pl sql developer in future?

0 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

What does fetching a cursor do?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

What is foreign key sql?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---