Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: compute statistics for a big table for the first time

Re: compute statistics for a big table for the first time

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Thu, 27 Feb 2003 21:26:11 +0100
Message-ID: <b3lsa4$1mau2j$1@ID-183343.news.dfncis.de>

Hi Chris,

like Sybrand said, 1 million rows aren't big and use dbms_stat. Another way is analyze estimate on the table and an analyze compute on the indexes if your rows are sorted.
hth
Kay Received on Thu Feb 27 2003 - 14:26:11 CST

This message: [ Message body ]
Next message: Gabriel Gonzalez: "Re: Copy with PK problem in oracle 9i"
Previous message: David Nguyen: "Copy with PK problem in oracle 9i"
In reply to: cris: "compute statistics for a big table for the first time"
Next in thread: chan01: "Re: compute statistics for a big table for the first time"

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