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
- 7825 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 |
What is the Difference between DSS & OLTP?
Different circumstance which drives informatica server to expel records?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What are the uses of a Parameter file?
How to elaborate powercenter integration service?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
Can we get 1st record through Informatica(without sequence number).
How to eliminate duplicates in FF and oracle both
explain different levels in pushdown optimization with example?
If we have lookup table in workflow how do you trouble shhot to increase performance?
Teradata 
