Change in execution plan if index added

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Mon, 6 Nov 2000 10:42:52 -0500
Message-Id: <10672.121210@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04808.3E53FEF0
Content-Type: text/plain;

charset="iso-8859-1"

I have SQL statement that was executed several times and it use bind variables. Then I added index and with next execution it began to use added index - looks like it was reparsed. Could somebody please why why it happen.

Alex Hillman

------_=_NextPart_001_01C04808.3E53FEF0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Change in execution plan if index added</TITLE>
</HEAD>
<BODY>

I have SQL statement that was executed =
several times and it use bind variables. Then I added index and with = next execution it began to use added index - looks like it was = reparsed. Could somebody please why why it happen.

  


Alex Hillman


</BODY>
</HTML>

------_=_NextPart_001_01C04808.3E53FEF0-- Received on Mon Nov 06 2000 - 09:42:52 CST