1.0Database Tutorialshttps://dbtut.comdbtuthttps://dbtut.com/index.php/author/dbtut/Query Hints in SQL Server - Database Tutorialsrich600338<blockquote class="wp-embedded-content" data-secret="zxDkEJxofr"><a href="https://dbtut.com/index.php/2019/05/10/query-hints-in-sql-server/">Query Hints in SQL Server</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://dbtut.com/index.php/2019/05/10/query-hints-in-sql-server/embed/#?secret=zxDkEJxofr" width="600" height="338" title="“Query Hints in SQL Server” — Database Tutorials" data-secret="zxDkEJxofr" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://dbtut.com/wp-includes/js/wp-embed.min.js
/* ]]> */
</script>
https://dbtut.com/wp-content/uploads/2019/05/Adsız-22.png776431What is Query Hint? You can change the execution plan of the query by adding the query hints to the end of the query. For example, if you add the maxdop query hint to the end of a query that uses a single CPU, the query may use multiple CPUs(parallelism). Or, you can use the …