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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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
  • Manickam
    [...] 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following