what is the hint?
how to use it to reduce the query processing in program?
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 are the data movement modes in informatcia?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What are ETL Tools?
how to run the batch using pmcmd command
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
If u select groupby port in aggregator what is output and dont select groupby option what is output
How we can use union transformation?
What are different types of transformations available in informatica?
What is a design?
What is target load order?