Answer / bala

By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..

Answer / ramprasad.s

hi



using oracle-Tuning




sun_ramprasad@yahoo.com

What is function and procedure in pl sql?

0 Answers  

---

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

---

Explain the components of sql?

0 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

Explain character-manipulation functions?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

How to update salary of employees department wise?

6 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---