tag:blogger.com,1999:blog-2257062243512934022.post6334085956222688380..comments2023-10-31T18:51:23.836+05:30Comments on Sachin Arora's Blog: Optimizer_mode – ALL_ROWS or FIRST_ROWS?Sachinhttp://www.blogger.com/profile/04551992629821526364noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-2257062243512934022.post-32541914197608277722012-12-17T09:40:38.610+05:302012-12-17T09:40:38.610+05:30Superb!!Superb!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-10237051734884290892012-09-17T12:59:00.363+05:302012-09-17T12:59:00.363+05:30Job Well doneJob Well doneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-22910129649643149242012-03-03T16:11:51.372+05:302012-03-03T16:11:51.372+05:30Excellent sachin... nice article on optimizer mode...Excellent sachin... nice article on optimizer modes..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-1520424200602649362011-11-12T10:47:24.706+05:302011-11-12T10:47:24.706+05:30Excellent Sachin. Thanks for your time to explain ...Excellent Sachin. Thanks for your time to explain in easy way to understandAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-28611424119972817182011-10-23T11:24:50.079+05:302011-10-23T11:24:50.079+05:30Thank you nice explanationThank you nice explanationBhanuhttps://www.blogger.com/profile/01295816011986549850noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-23826624939771926632010-10-30T01:34:34.468+05:302010-10-30T01:34:34.468+05:30Awesome Blog. Helped me understand the basics.Awesome Blog. Helped me understand the basics.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-24663068984434177122010-10-30T01:32:44.105+05:302010-10-30T01:32:44.105+05:30This blog is really awesome. Helped me to understa...This blog is really awesome. Helped me to understand the basics concepts. Thanks a lot.Vanithanoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-87162797580043812582010-10-16T00:28:08.584+05:302010-10-16T00:28:08.584+05:30Great info. Thank you!Great info. Thank you!Unknownhttps://www.blogger.com/profile/13668471074490773868noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-32338090676514523912009-09-29T21:05:43.235+05:302009-09-29T21:05:43.235+05:30Great article ! It saved me a lot of reading ;)Great article ! It saved me a lot of reading ;)PSnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-58630309953077528122009-09-10T12:29:22.029+05:302009-09-10T12:29:22.029+05:30Nice articvle..
I feel first_rows is used for the...Nice articvle..<br /><br />I feel first_rows is used for the report queries only anot in general for the OLTP systems.<br /><br />In OLTP all_rows is used as the rows to be processed is usually very less.Harmandeep Singhhttps://www.blogger.com/profile/07723334323481256648noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-30873758874625414382009-05-22T01:59:25.736+05:302009-05-22T01:59:25.736+05:30Nice explainations in simple manner.Keep it up Sac...Nice explainations in simple manner.Keep it up Sachin... We are expecting more articles about the performance of database...<br />Thanks a lot.<br /><br />Ashwin...Unknownhttps://www.blogger.com/profile/12970581286750308437noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-30975349161779301672009-02-06T20:42:00.000+05:302009-02-06T20:42:00.000+05:30Very good explanationVery good explanationvprasadhttps://www.blogger.com/profile/03522878862486854526noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-65271758818039820172009-02-04T05:35:00.000+05:302009-02-04T05:35:00.000+05:30Excellent note......Excellent note......Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-61866259538682915142009-01-27T05:47:00.000+05:302009-01-27T05:47:00.000+05:30Simply Great Article!!!Simply Great Article!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-72216390026922119712008-06-25T12:33:00.000+05:302008-06-25T12:33:00.000+05:30Hi sachin,Very nice explanation regarding optimize...Hi sachin,<BR/>Very nice explanation regarding optimizers..nice differnce between all_rows and first_rowsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-80125128644399043902008-06-11T10:48:00.001+05:302008-06-11T10:48:00.001+05:30Awesome Job....Simple things makes life easyAwesome Job....Simple things makes life easyUnknownhttps://www.blogger.com/profile/07176412964166916530noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-51936574400749152252008-06-11T10:48:00.000+05:302008-06-11T10:48:00.000+05:30Awesome Job....Simple things makes life easyAwesome Job....Simple things makes life easyUnknownhttps://www.blogger.com/profile/07176412964166916530noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-22905958184758248272008-06-05T16:39:00.000+05:302008-06-05T16:39:00.000+05:30Great explanation... -Wandi-Great explanation... -Wandi-Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-15449607976209061302008-05-29T12:35:00.000+05:302008-05-29T12:35:00.000+05:30ExcellentExcellentAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-13457860548235319912008-05-07T17:52:00.000+05:302008-05-07T17:52:00.000+05:30Good explanation Sachin.Keep Doing.Good explanation Sachin.<BR/>Keep Doing.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-64765359996948354352008-01-15T11:06:00.000+05:302008-01-15T11:06:00.000+05:30superb article about optimizer_mode= first_rows/al...superb article about optimizer_mode= first_rows/all_rows.<BR/><BR/>thanks for providing thid details.<BR/><BR/>cheers<BR/><BR/>prakashPrakash GRhttps://www.blogger.com/profile/11684787069654593292noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-1894505546848192392008-01-14T21:53:00.000+05:302008-01-14T21:53:00.000+05:30Thanks Anand for your feedback. You may read http:...Thanks Anand for your feedback. You may read http://oracle-online-help.blogspot.com/2007/03/nested-loops-hash-join-and-sort-merge.html for diff b/w nested loop and hash joins.Sachinhttps://www.blogger.com/profile/04551992629821526364noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-5037047554191575532008-01-14T18:48:00.000+05:302008-01-14T18:48:00.000+05:30Can you pls explain difference b/w Nested loops an...Can you pls explain difference b/w Nested loops and hash joins? Or recommend a good note.<BR/><BR/>Thankyou !Anand Diwanhttps://www.blogger.com/profile/07690711387880033813noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-6745768399431636052008-01-14T18:45:00.000+05:302008-01-14T18:45:00.000+05:30Superb note !Superb note !Anand Diwanhttps://www.blogger.com/profile/07690711387880033813noreply@blogger.com