Re: Optimize Table
From: bdbafh <bdbafh_at_gmail.com>
Date: Thu, 31 Jan 2008 07:29:18 -0800 (PST)
Message-ID: <2e3a194d-4c2c-49dc-8fc4-e3b233ce559f@l1g2000hsa.googlegroups.com>
Date: Thu, 31 Jan 2008 07:29:18 -0800 (PST)
Message-ID: <2e3a194d-4c2c-49dc-8fc4-e3b233ce559f@l1g2000hsa.googlegroups.com>
On Jan 31, 9:19 am, mansoor..._at_gmail.com wrote:
> There is command 'Optimize Table' in MySQL. What is the equivalent of
> this in Oracle?
> And if none, how to optimize an Oracle (10g) table?
>
> Thx.
truncate
Guaranteed to speed along any operation.
-bdbafh Received on Thu Jan 31 2008 - 09:29:18 CST