Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does the sql command "analyze" will lock the table?
ANALYZE TABLE ... COMPUTE STATISTICS does not lock the table. Only ANALYZE TABLE ... VALIDATE STRUCTURE locks the table. Try it yourself!
--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah
On Wed, 16 Sep 1998, skv wrote:
>
> EUNG CHI WAH пишет в сообщении <35ff423f.0=
@ruby.hknet.com> ...
> >As title, does "analyze" will lock up the table
> >while it is analyzing a table?
>
> ANALYZE TABLE ... COMPUTE STATISTICS - locks the table
> ANALYZE TABLE ... ESTIMATE STATISTICS - no
Received on Wed Sep 16 1998 - 17:01:24 CDT