Interested to Buy Any Domain ? << Click Here >> for more details...
what is the hint?
how to use it to reduce the query processing in program?
- 3 Answers
- 7843 Views
- Cegedim, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / usha
Hints is nothing but clues.
By using hints we can improve the query performence.
| Is This Answer Correct ? | 2 Yes | 2 No |
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....
| Is This Answer Correct ? | 0 Yes | 0 No |
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is a joiner transformation?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Do you find any difficulty while working with flat files as source and target?
wht is full process of Information source to target just like stg to productuon and development
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
What is aggregate awareness?
How can you access the remote source into your session?
Teradata 
