Supress ERROR LOG "join order enforced" warning on join hints

Posted on 2008-11-06
Last Modified: 2012-05-05
Sometimes I use join hints. That produces a warning record in the SQL Error log:
Procedure XYZ output the following:  'Warning: The join order has been enforced because a local join hint is used.' on every execution.

Is there a way to supress these warning messages?
What is the cost of writing these messages to my procedure performance?
Question by:aionine
    LVL 26

    Accepted Solution

    Join hints enforces the sql engine use different execution plans then the server choose.. Since the cost of these plans do differ sql a-warns you about the usage of the join hint. If you are not sure that you really need that hints my recommendation is that do not use the join hints... In order to decide wether to to use or not you can measure the query performnces with hints and without hints. Wich is perforning fast choose that one.
    LVL 51

    Expert Comment

    by:Mark Wills
    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup topic area:
       Acccept: tigin44 {http:#22915994}

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    EE Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now