How to rewrite a LEFT OUTER JOIN query?

• Sorin Petcu

  Hall of Fame

  Points: 3195

  More actions

  October 19, 2007 at 4:28 am

  #743506

  What is means Bookmark Lookups (see attach) ? I have some big values for its.

  In Theory, theory and practice are the same...In practice, they are not.

• Sorin Petcu

  Hall of Fame

  Points: 3195

  More actions

  October 19, 2007 at 4:32 am

  #743509

  Maybe I have nothing to optimize by means of SQL. Maybe only hardware.

  In Theory, theory and practice are the same...In practice, they are not.

• Jeff Gray

  SSChampion

  Points: 10667

  More actions

  October 19, 2007 at 1:03 pm

  #743766

  Sorin Petcu (10/19/2007)

  ---

  What is means Bookmark Lookups (see attach) ? I have some big values for its.

  The bookmark lookup happens when the qurey processor uses an index to find the rows that it needs from a particular table, when the columns that it needs from that table are not part of the index that was used to identify the rows. So, it has to go back to the table to get the rest of the data it needs.