optimization of joins

pts.
Tags:
Oracle
SQL Server
hai everybody, can u give me some tips on to run my joins faster.. using hints on joins will increase or decrease the performance.. how to change the order of joins, give me some eg.. thanks in advance

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you’re talking about hints, you must be using Oracle. Don’t worry about join order, or about hinting. Oracle has an optimizer that plans out your queries. The use of hints is only needed when you know better than Oracle does how everything should be processed. Since Oracle does a reasonable job, you generally won’t need to do any of this. If you want details on what Oracle is planning, look up EXPLAIN PLAN and/or HINT in the Oracle manual.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Sk26432
    it depend upon how u use hint some time it is very useful to use. but if u suggest wrong index then performance will defiantly decrease
    0 pointsBadges:
    report
  • optimization of joins (Q/A) | Seek The Sun Slowly
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/optimization-of-joins/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: