Answer Posted / kapil

By using index (not always)
by using bulk fetch
by using exists and not exists in place of in and not in
clause.
by avoiding implicit conversion by oracle
ex: if in employee table emp_no is varchar then
if we query the data from employee table by
where cluase like employee_number = 123 then oracle will
have to implictly convert the number 123 to
varhcar '123'and will require time

Does pl sql work in mysql?

953

---

What is constant in pl sql?

1006

---

What is the purpose of the sql select top clause?

1088

---

how to check myisam tables for errors? : Sql dba

1305

---

Can you have more than one trigger on a table?

986

---

How do you remove duplicate records from a table?

927

---

How do I remove all records from a table?

1062

---

How to run sql statements through the web interface?

1021

---

What does over partition by mean in sql?

958

---

how to use 'mysql' to run sql statements? : Sql dba

1037

---

What is parameter substitution in sql?

1014

---

What is program debugging?

1219

---

Is crud a cuss word?

1015

---

How to rename a column in the output of sql query?

1064

---

What is a table partition?

1106

---