Home Forums SQL Server 7,2000 Performance Tuning Bookmark Lookup Options... RE: Bookmark Lookup Options...
David O
Hall of Fame
Points: 3228
More actions
April 9, 2008 at 3:16 pm
#800658
Most of them are pretty good but you got two I'm thinking could be a problem.
If you've go the maintenance window. I'd run dbcc dbreindex against the whole table plus you get a full stats update.
David