Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: query tune

Re: query tune

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 16 Mar 2005 09:23:44 +0000
Message-ID: <7765c89705031601233a567f1b@mail.gmail.com>


drop database ... is there in 10g, perhaps they had its usefulness as an answer to opaque questions in mind. It would take Carel-Jan's excellent comment about never executing the statement to a more appropriate level, that of never executing any statement. Performance heaven.

On Wed, 16 Mar 2005 00:54:56 -0000, Tanel P=F5der <tanel.poder.003_at_mail.ee>=  wrote:
> Someone should file an enhancement request for "truncate database" comman=
d,
> this would not only be faster, but also more automatic!

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 16 2005 - 04:27:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US