Answer Posted / abhijit

Use query analyzer to see the execution path and find
bottlenecks such as full table scans for tables with huge
number of rows.

Make sure you use the indexed columns in where clause, this
can lead to a phenomenal jump in query execution speed.

What is not null in sql?

1058

---

What is the usage of nvl function?

1040

---

How do I save a stored procedure?

1009

---

What is Histogram?

1560

---

How to look at the current sql*plus system settings?

1150

---

What is a null value?

1145

---

what are properties of a transaction? : Sql dba

1094

---

What is fmtonly in sql?

1086

---

How do you determine the current isolation level? : Transact sql

1159

---

Is sql an operating system?

1020

---

What are different types of queries in sql?

1121

---

How many types of relationship are there?

1031

---

How much does sqlite cost?

1040

---

What are types of exception?

922

---

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

1032

---