toracleoutput hint

Six Stars

toracleoutput hint

HI please provide an example for using advance settings like hint and other options in toracleoutput


Accepted Solutions
Employee

Re: toracleoutput hint

Hi,

 

     Hints are tuning tools of past and Oracle database is intelligent enough to identify the best performance route by itself.

 

     So if you are trying to force Hints to Oracle, it may in turn degrade the performance of Oracle DB.

 

     Please also refer the link below from Oracle AskTom site for details.

 

https://asktom.oracle.com/pls/asktom/f?p=100:11:0:::Smiley Tongue11_QUESTION_ID:7038986332061

 

      If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)

 

Warm Regards,

 

Nikhil Thampi


All Replies
Employee

Re: toracleoutput hint

Hi,

 

     Hints are tuning tools of past and Oracle database is intelligent enough to identify the best performance route by itself.

 

     So if you are trying to force Hints to Oracle, it may in turn degrade the performance of Oracle DB.

 

     Please also refer the link below from Oracle AskTom site for details.

 

https://asktom.oracle.com/pls/asktom/f?p=100:11:0:::Smiley Tongue11_QUESTION_ID:7038986332061

 

      If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)

 

Warm Regards,

 

Nikhil Thampi

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now