Query Optimisation

Posted by sladescross on October 7, 2010

http://stackoverflow.com/questions/1395275/which-is-better-bookmark-key-lookup-or-index-scan
Key (Bookmark) lookup versus index seek.
Seeing a Key Lookup should not scare you. Is the normal operator used in Nested Loops, and Nested Loops is the run-of-the-mill join operator. If you want to improve a... [read more]

Rating

not rated
Login to rate this.

Reviews

Submit a comment / review

There are currently no comments or reviews.

Related

  • I’m trying to execute an SQL insert query using LINQ and returning the ID field. My code does not work, can anybody tell me if my syntax is wrong? s...
    By Programmer's Goodies on September 16, 2011
  • Topic: SharePoint 2010, FS4SP, FAST Search Server 2010, FIXMLSubject: Index corruption and rebuilding the FS4SP index from FIXMLProblem: My FS4SP inde...
    By Eric Belisle on September 15, 2011
  • Few years back I blogged about adding OpenID login support in ASP.NET application. This time I am blogging about adding Google login support in ASP.N...
    By Prashant Khandelwal on February 18, 2012
  •   This post is a part of a series of posts about query design. For the previous post see: http://blogs.msdn.com/vladimirsadov/archive/2007/06/08/...
    By VladimirSadov on June 9, 2007
  • In SharePoint 2010 throttling is enabled by default (This is configurable however in Central Administration). Throttlng is set to not display list vie...
    By nathbr on February 25, 2011
  • We are pleased to announce the release of EntitySpaces 2012. The version number is 2012.1.0229.0, we just couldn't pass up th...
    By Mike Griffin (EntitySpaces) on February 29, 2012
  • http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2011/12/08/using-search-to-find-recently-modified-files-in-sharepoint-2010.aspx?utm_source=...
    By sladescross on December 15, 2011
  • Microsoft.SharePoint.SPQuery object has Query property that accepts a CAML fragment, which defines the query to be performed. A ViewFields property...
    By Fewlines4Biju on April 21, 2011

Submit a review:

Login required.