Re: Rewrite a WHERE clause

From: "--CELKO--" <jcelko212@xxxxxxxxxxxxx>
Date: 30 Aug 2005 08:01:44 -0700

I thought that 2005 was geting a "multi-plan" feature like DB2. It
actually saves multiple exection plans and effectively does what AK
proposed, but without you having to tell it. Do you know if the OPTION
(RECOMPILE) discards or saves prior plans?

.

Follow-Ups:
- Re: Rewrite a WHERE clause
  - From: Erland Sommarskog
- Re: Rewrite a WHERE clause
  - From: joshsackett

References:
- Rewrite a WHERE clause
  - From: joshsackett
- Re: Rewrite a WHERE clause
  - From: --CELKO--
- Re: Rewrite a WHERE clause
  - From: Erland Sommarskog

Prev by Date: SMC violating Microsoft license agreements?
Next by Date: Re: Convert float to char
Previous by thread: Re: Rewrite a WHERE clause
Next by thread: Re: Rewrite a WHERE clause
Index(es):
- Date
- Thread