aionine
asked on
Supress ERROR LOG "join order enforced" warning on join hints
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
mark_wills
EE Cleanup Volunteer