performance problem

microsoft.public.sqlserver.programming

31 Dec 2005 8:56 AM

Roy Goldhammer

Hello there

I have table with more then 30,000,000 records.

When i do simple select on 3 fields who are indexes, i see on the execution
plan 90% on bookmark lookup.

What can cause this?

30 Mar 2006 1:59 PM

Raymond D'Anjou

"Roy Goldhammer" <r**@hotmail.com> wrote in message
news:Oea7Jf9UGHA.4792@TK2MSFTNGP14.phx.gbl...
> Hello there
>
> I have table with more then 30,000,000 records.
>
> When i do simple select on 3 fields who are indexes, i see on the
> execution plan 90% on bookmark lookup.
>
> What can cause this?

Date: Sat, 31 Dec 2005 10:56:24 +0200
Roy, fix your system clock please.
You're still celebrating New Years Eve.