Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select count(*)
Hi,
I am new in ORACLE. I tried the analyse statement but it does not show anything:
analyze table item compute statistics
it displays nothing. Would you mind teaching a newbie a bit?
dhruba <tapashc_at_my-deja.com> wrote in message
news:8lqa61$7l9$1_at_nnrp1.deja.com...
> 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
>
> on my machine NT4 with SP6 524MB RAM ,
> select count(*) from table1 takes around about 1 mt 40 secs;
> select count(1) from table1 also takes 1mt 20 secs.
>
>
> I have a primary key on this table .
> and some column indexes.
>
> .. The database size is approx 4GB
> .. Index tablespace are different from data tablespace.
>
> table & index storage parameter not taken care.
>
> In this is this performence OK?
> or it can be improved & how ?
>
> any advice will be appreciated
> Thanks in advance
>
> Tcy
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT