Re: select count(*)

From: GC <assistant_madman_at_hotmail.com>
Date: 2000/07/27
Message-ID: <3980C798.A44EC5BB@hotmail.com>#1/1

dhruba wrote:
>
> Hi,
>
> I have a table of 10 million rows with 20 columns
>
> analyze table1 shows this:-----
>
> NUM_ROWS AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE BUFFER_
> --------- --------- ----------- ----------- -------
> 9342920 227 61 1064 DEFAULT
Unrelated to your question, but important nonetheless - next time you analyze your table, use a bigger sample size than the default of 1064 rows. Perhaps 'analyze table <table_name> estimate statistics sample 30 percent;', or more if you have the temp space.

Cheers,
GC Received on Thu Jul 27 2000 - 00:00:00 CDT