News for hackers. Stuff that matters.
Re:Why PostgreSQL doesn't have query hints by Ingaz on Saturday February 05, 2011 @03:14AM (#2182724)
WITH RECOMPILE does opposite effect. It's kind of anti-hint.

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.