How to rewrite a LEFT OUTER JOIN query?

Question

Post reply

How to rewrite a LEFT OUTER JOIN query?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Sorin Petcu Hall of Fame Points: 3195 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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.