Message-Id: <10672.121210@fatcity.com> From: Alex Hillman Date: Mon, 6 Nov 2000 10:42:52 -0500 Subject: Change in execution plan if index added 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 Change in execution plan if index added

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--