|
|
|
Date Submitted:
08/04/05
Hits: 67 Rating:  based on 0 votes
Speed Up SELECT DISTINCT QueriesAdded by Papergrl
Description:
The reason the second example runs slightly quicker is that the EXISTS clause will cause a name to be returned when the first book is found, and no further books for that author will be considered (we already have the author's name, and we only want to see it once)
Read the Complete Paper You don't have permission to post replies. Please login or register. |