Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!h11g2000prf.googlegroups.com!not-for-mail From: Noons Newsgroups: comp.databases.oracle.server Subject: Re: Tom Kyte's book obsolescence Date: Sat, 2 Feb 2008 03:33:47 -0800 (PST) Organization: http://groups.google.com Lines: 16 Message-ID: References: NNTP-Posting-Host: 124.170.8.156 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1201952027 5722 127.0.0.1 (2 Feb 2008 11:33:47 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 2 Feb 2008 11:33:47 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: h11g2000prf.googlegroups.com; posting-host=124.170.8.156; posting-account=k_-hrQkAAAB7Bn31Ny_axT_cffxv_RbI User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe) Bytes: 1783 Xref: usenetserver.com comp.databases.oracle.server:441024 X-Received-Date: Sat, 02 Feb 2008 06:33:48 EST (text.usenetserver.com) On Feb 2, 2:02 am, Mladen Gogala wrote: > > This discovery is loaded with implications: > 1) Oracle does I/O in versions 10g and 11g in the different way then it > used to in versions 9i and below. I am not sure what exactly is the > difference, but there is a difference. > 2) Analytic functions are now just a neat trick, no longer a performance > improvement. The cost of the window buffer sort is relatively high > compared to the cost of simple join. > 3) Some information in "Effective Oracle by Design" is obsolete. How much, > exactly? Good catch, Mladen. Thanks for that.