Thursday, January 03, 2008

gender stereotypical joke

Sideswipe - New Zealand Herald - 01 Jan 2008

So, a woman goes to the Husband Store to find a husband.

The sign on the first-floor door reads Floor 1: These men have jobs.
The second-floor sign reads: Floor 2: These men have jobs and love kids.
The third-floor sign reads: Floor 3: These men have jobs, love kids and are extremely good looking.

"Wow," she thinks, but feels compelled to keep going. She goes to the fourth floor and the sign reads: Floor 4: These men have jobs, love kids, are good looking and help with housework.

"Oh, mercy me!" she exclaims, "I can hardly stand it!" Still, she goes to the fifth floor and the sign reads: Floor 5: These men have jobs, love kids, are drop-dead gorgeous, help with housework and have a strong romantic streak.

She is so tempted to stay, but she goes to the sixth floor and the sign reads: Floor 6: You are visitor number 31,456,012 to this floor. There are no men on this floor. This floor exists solely as proof that women are impossible to please. Thank you for shopping at the Husband Store.

To avoid gender bias charges, the store's owner opens a New Wives store just across the street. The first floor has wives that love sex. The second floor has wives that love sex and have money. The third, fourth, fifth and sixth floors have never been visited.

Why to use Exists rather than Count(*)

Andrew Kelly : Exists Vs. Count(*) - The battle never ends...
Both queries scanned the table but the EXISTS was able to at least do a partial scan do to the fact it can stop after it finds the very first matching row. Where as the COUNT(*) must read each and every row in the entire table to determine if they match the criteria and how many there are.