Yup. The speed depends more on the dataset

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #28,226

by tseliot

2/13/02 10:21:53 AM

Yup. The speed depends more on the dataset

You didn't tell us whether .id was a unique index for either a or b (or both)?

---------------------------------
A stupid despot may constrain his slaves with iron chains; but a true politician binds them even more strongly by the chain of their own ideas;...despair and time eat away the bonds of iron and steel, but they are powerless against the habitual union of ideas, they can only tighten it still more; and on the soft fibres of the brain is founded the unshakable base of the soundest of Empires."

Jacques Servan, 1767

Question on LEFT JOIN - (drewk) - (12) - Feb. 12, 2002, 02:46:08 PM EST

An unspecified joining query *is* a left join - (kmself) - (8) - Feb. 12, 2002, 03:03:37 PM EST

Hmm, I don't think so - (drewk) - (7) - Feb. 12, 2002, 03:10:53 PM EST

No, "JOIN [tables] ON [condition]" is Standard SQL-92 AFAIK. -NT - (CRConrad) - Feb. 12, 2002, 05:38:08 PM EST

Left Join. - (static) - (5) - Feb. 12, 2002, 10:17:34 PM EST

re: inner/outer left/right joins - (tablizer) - (4) - Feb. 20, 2002, 01:07:50 PM EST

Nope, they're really more kind'a the same thing. - (CRConrad) - (3) - Feb. 20, 2002, 01:58:16 PM EST

Anybody ever do a FULL OUTER ? - (tablizer) - Feb. 21, 2002, 01:54:34 PM EST

I like that description. - (static) - (1) - Feb. 24, 2002, 12:34:51 AM EST

You're welcome! (Both of you... ;^) -NT - (CRConrad) - Feb. 25, 2002, 12:48:00 PM EST

been a long time but wouldnt a stripped seek be faster - (boxley) - (2) - Feb. 12, 2002, 03:20:15 PM EST

Gaah, just got the answer - (drewk) - (1) - Feb. 12, 2002, 03:28:43 PM EST

Yup. The speed depends more on the dataset - (tseliot) - Feb. 13, 2002, 10:21:53 AM EST

iwethey.org

Internet Face Stuff!
65 ms