Monday, March 12, 2012

performance problem

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?"Roy Goldhammer" <roy@.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.

No comments:

Post a Comment