tag:blogger.com,1999:blog-2954359812249072053.post1339514539737517688..comments2023-12-15T23:33:59.034-06:00Comments on Cary Millsap: Filter EarlyCary Millsaphttp://www.blogger.com/profile/16697498718050285274noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2954359812249072053.post-37748952527157080422011-10-01T22:35:28.466-05:002011-10-01T22:35:28.466-05:00The most common filter late example I see is in da...The most common filter late example I see is in data warehousing. The staging area often pulls all columns and rows from a source table, because the business will ask for them soon enough so why touch the code twice.Arnoudhttps://www.blogger.com/profile/18429412522404140879noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-30129321578641874162010-06-16T13:12:18.848-05:002010-06-16T13:12:18.848-05:00I had a nice "filter late" experience tw...I had a nice "filter late" experience two weeks ago. <br /><br />We had an app go into 11g. Immediately upon implementation, a function that normally ran late in the execution plan suddenly started running very early (before filtering), in the driven part of a nested loops join. Instead of running 50,000 times, it started running 460 million times before finally being killed.Unknownhttps://www.blogger.com/profile/10189746986301717681noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-885504408125778272010-05-17T01:47:28.890-05:002010-05-17T01:47:28.890-05:00When I taught discoverer and the audience was by d...When I taught discoverer and the audience was by definition 'non technical', I explained filtering as being a basket of data, and each condition reduced the size of the basket. The example I would give was buttons. No point searching for a small white button with only 2 holes if your basket contained every button in the box. Bin or filter the coloured buttons, becuase as Chen says, that is easy; then start removing big, or 4 hole buttons. I also used this analagy to explain indexing.Debra Lilleyhttps://www.blogger.com/profile/06501850988908291461noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-82791505727050986222010-05-16T14:19:20.099-05:002010-05-16T14:19:20.099-05:00Burn the haystack?Burn the haystack?Brian Tkatchhttps://www.blogger.com/profile/11320700842381820277noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-50874102447062630332010-05-15T10:41:41.734-05:002010-05-15T10:41:41.734-05:00President Nixon letting Haldeman and Ehrlichman sc...President Nixon letting Haldeman and Ehrlichman screen all his visitors and prepare digests of newspapers so he wouldn't have to read the originals (he boasted of this last practice to journalists).Stew Ashtonhttps://www.blogger.com/profile/10004507258457241890noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-71740856582663053692010-05-14T20:23:37.021-05:002010-05-14T20:23:37.021-05:00An excellent 'filter early' is when Oracle...An excellent 'filter early' is when Oracle decides that, due to a constraint, a certain predicate can never be true for a table row and it doesn't even both to check the table.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-40157837950158327722010-05-14T14:13:42.796-05:002010-05-14T14:13:42.796-05:00Similar to the second one and main reason of our y...Similar to the second one and main reason of our yearly fights with my wife :)<br /><br />Filter your £X of goods before you close the holiday luggage, so you won't have to pay £2X extra luggage fee when you realize you are 5kg more and it is £5 per kgCoskan Gundogarhttps://www.blogger.com/profile/11570869033287689498noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-66902534736314947722010-05-14T13:58:36.072-05:002010-05-14T13:58:36.072-05:00@Chen, exactly.
Now, ...what great Filter Early (...@Chen, exactly.<br /><br />Now, ...what great Filter Early (or Filter Late) examples do we have out there?Cary Millsaphttps://www.blogger.com/profile/16697498718050285274noreply@blogger.comtag:blogger.com,1999:blog-2954359812249072053.post-35144018822991016962010-05-14T13:56:35.790-05:002010-05-14T13:56:35.790-05:00brass needles? So I can't filter them easily b...brass needles? So I can't filter them easily by sight (color) or by magnet.Chen Shapirahttps://www.blogger.com/profile/14535067086703072776noreply@blogger.com