Re: re creating a primary key on a table makes requests faster?

On 17 Dez., 11:26, "Wilfrid" <grill..._at_yahoo.com> wrote:
> Would their be any reason why removing a primary key and recreating it on a
> reasonibly large table (~160000 records and increasing at steady rate, with
> int, nvarchar, bit and datetime columns), would have an impact on select and
> insert performance?
> Is there some kind of fragmentation on a table that could explain this?
> thanks in advance for your insight

Richard Foote wrote quite a bit about this: http://richardfoote.wordpress.com/2007/12/11/index-internals-rebuilding-the-truth/ http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf

Kind regards

robert Received on Mon Dec 17 2007 - 07:25:02 CST