IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Gaah, just got the answer
Post #28,143
by drewk
Picture of drewk
2/12/02 3:28:43 PM
Reply
New 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
Picture of tseliot
2/13/02 10:21:53 AM
Reply
New 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

I can see it now. New posts in IWETHEY Forum Guidelines requiring that bunches of wourds must nouw countain supueurufuluuuouuus u's scattered abuout.
50 ms