Re: Does the sql command "analyze" will lock the table?

From: skv <skv_at_kpbank.ru>
Date: Wed, 16 Sep 1998 12:54:48 +0800
Message-ID: <6tnfs1$eh7$1@home.kpbank.ru>

EUNG CHI WAH ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <35ff423f.0_at_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

Regards

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
          mailto:skv_at_kpbank.ru

Received on Tue Sep 15 1998 - 23:54:48 CDT

This message: [ Message body ]
Next message: skv: "Re: How many bytes to store DATE info in Oracle?"
Previous message: LEUNG CHI WAH: "Does the sql command "analyze" will lock the table?"
In reply to: LEUNG CHI WAH: "Does the sql command "analyze" will lock the table?"
Next in thread: Jeremiah Wilton: "Re: Does the sql command "analyze" will lock the table?"
Reply: Jeremiah Wilton: "Re: Does the sql command "analyze" will lock the table?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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