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.

Can sql developer connect to db2?

985

---

What jobs use sql?

925

---

Is postgresql a server?

995

---

How do you pronounce sql?

955

---

what does myisamchk do? : Sql dba

961

---

Can you inner join the same table?

934

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

984

---

What is the reports view in oracle sql developer?

924

---

What is sqlca in db2?

890

---

What are the different types of tables in sql?

929

---

What does count (*) mean?

873

---

What is varray in pl sql?

1007

---

What operators deal with null?

1029

---

What sql database should I use?

1072

---

What is the use of sqldataadapter?

907

---