Answer Posted / asr

Avoid the sub queries.
Where condition should be based on primary key and index,
use primary column for join.
Try to avoid more tables.
Use temp tabels.
Create procedure.

What is use of package in pl sql?

529

---

How does postgresql compare to oracle/db2/ms sql server/informix?

561

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

554

---

What is oracle sql developer?

603

---

What is a data definition language?

548

---

---

Does sql profiler affect performance?

551

---

Can we create index on primary key?

522

---

what are date and time data types in mysql? : Sql dba

495

---

Can you have a foreign key without a primary key?

507

---

What is sqlca in db2?

530

---

What is user defined functions?

573

---

What is oracle pl sql developer?

529

---

Does execute immediate commit?

695

---

What is the use of nvl function?

616

---

Why query optimization is needed?

511

---