Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Why PostgreSQL doesn't have query hints. Parent comment
You force SQLServer to never use cached plans and regenerate query plan every time you run query. So you have always "plan generation overhead".
Also, such SP can have only 1 running example in server because of SP:Recomile Lock. Kind of singleton in SQLServer.
There are no comments on this comment yet.
You force SQLServer to never use cached plans and regenerate query plan every time you run query. So you have always "plan generation overhead".
Also, such SP can have only 1 running example in server because of SP:Recomile Lock. Kind of singleton in SQLServer.