Answer / sujatha

Hi,

Hints are used to improve the query performance. Please go
through the below link ...u will get all the info
required...
http://www.adp-gmbh.ch/ora/sql/hints/index.html

Answer / usha

Hints is nothing but clues.
By using hints we can improve the query performence.

Answer / gazulas

by using hints we can direct the optimizer to follow what was specified in the hints. ex: we can direct the optimizer to do a index unique scan instead of full table scan....

Which files are created during the session rums by informatics server?

0 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

in performance wise union is past,union all is past

2 Answers  

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---

---

How do we call shell scripts from informatica?

0 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

What is difference between a connected look up and unconnected look up?

6 Answers  

---

what is workflow varible

1 Answers   HP,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

What do you understand by term role-playing dimension?

0 Answers  

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---