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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.