Re: query tune
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Mar 2005 00:54:56 -0000
Someone should file an enhancement request for "truncate database" command,
this would not only be faster, but also more automatic!
Tanel.
----- Original Message -----
From: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
To: <gorbyx@xxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, March 16, 2005 12:27 AM
Subject: Re: query tune
>I don't understand this truncate solution. We all know that when this
> kind of reorganization has to be repeated on a regular basis, the
> truncate isn't a real silver bullet. One should find the root cause of
> the problem, and solve that. In this case, I would simply drop the
> table. That saves a lot of future work, and performance can not degrade
> again. Of course the statement will fail then, but as many teachers
> tought us: The best way to execute a statement is stop executing it.
> Problem solved.
> Just my $0.02
--
//www.freelists.org/webpage/oracle-l
Other related posts:
