been a long time but wouldnt a stripped seek be faster

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

Welcome to IWETHEY!

Post #28,142 by boxley 2/12/02 3:20:15 PM Reply	been a long time but wouldnt a stripped seek be faster on tables that large. thanx, bill "If you're half-evil, nothing soothes you more than to think the person you are opposed to is totally evil." Norman Mailer
Post #28,143 by drewk 2/12/02 3:28:43 PM Reply	Gaah, just got the answer The laft join syntax forces the order the tables will be scanned. On the particular query I was doing, when a regular join was used the optimizer picked the wrong order. Rather than use the keywords that direct the optimizer what to do, they just converted it to left joins. We have to fight the terrorists as if there were no rules and preserve our open society as if there were no terrorists. -- [link\|http://www.nytimes.com/2001/04/05/opinion/BIO-FRIEDMAN.html\|Thomas Friedman]
Post #28,226 by tseliot 2/13/02 10:21:53 AM Reply	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

Beware of things that go blimp in the night...
114 ms