Answer Posted / hutashan

Avoid implicit datatype conversion
Avoid using function on an indexed column
Avoid comparing column value with NULL
Outer Join
Use OR carefully

Always use NOT EXISTS instead of NOT IN


Use UNION ALL whenever possible (no implicit sorts)
UNION will sort the result set for each SELECT before
combining the final result set
Remove DISTINCT keyword from SELECT if UNION is used

What is schema in sql?

941

---

Is natural join and inner join same?

913

---

What is sql architecture?

1041

---

how to use regular expression in pattern match conditions? : Sql dba

1018

---

What are the possible values for the boolean data field?

952

---

How do I debug a stored procedure?

1103

---

what is column? : Sql dba

999

---

What are the types of index in sql?

1059

---

Is it possible to read/write files to-and-from PL/SQL?

1095

---

What is a loop in sql?

975

---

How to pipe multiline string to isql?

1000

---

how to convert character strings to numeric values? : Sql dba

1098

---

What is dynamic sql in pl sql?

1025

---

What is a native sql query?

1056

---

What are the different set operators available in sql?

1013

---