Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!u29g2000pro.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Are there performancebenefits to reorganizing database-using export/import? Date: Tue, 11 Nov 2008 11:12:45 -0800 (PST) Organization: http://groups.google.com Lines: 27 Message-ID: <24a19072-454a-48cf-b519-fb445552d457@u29g2000pro.googlegroups.com> References: <5eaa2450-695b-4bc5-b88c-fceeaba480b6@i20g2000prf.googlegroups.com> NNTP-Posting-Host: 75.49.200.201 Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1226430766 22192 127.0.0.1 (11 Nov 2008 19:12:46 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 11 Nov 2008 19:12:46 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: u29g2000pro.googlegroups.com; posting-host=75.49.200.201; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-Via: 1.0 ISA2K4-OC1 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Nov 11, 7:04=A0am, bdbafh wrote: > > Why would you want to take the data out of the database? When I've done this in the long-ago-past, it was because it was just a little bit of my time to send off an exp/imp to run overnight, versus lots of time to deal with thousands of tables, which effectively meant never get done (though the real reason often had to do with disk space - exports were being taken regardless). Not a great reason, but if it had a demonstrable effect (and it did), then fine, even if it was really going through the entire data set just to fix a smaller portion of it. These days, there's likely going to be less of an effect, and it's not so time-consuming to spotlight problem tables/indices. Depending on your available tools and skills, of course. It still winds up being the SQL most of the time for most of the problems, anyways. The fastest code is the code you don't run. jg -- @home.com is bogus. =93Democrats, who want to redistribute wealth to 'Main Street,' fear the Wall Street vampires who bleed the nation dry. Republicans fear a revolt of the poor and disenfranchised, dressed in rags and coming to the White House to eat their brains.=94 - Annalee Newitz