Re: Oracle 9.2.0.1.0 For Windows performance question

>
> The duration of a count(*) is dependent of the size of the table and
> the location of High Water Mark. If you have a table of 1000 blocks,
> and 0 records, but the High Water Mark is at block 995, all 995
> blocks will be read.
> Also your db_file_multiblock_read_count may be inadequate per se, or
> be inadequate compared to the size of a single extent of your table
>
>

OK, so how can I update HWM of my table ? analyze or sthg command ? Received on Sat Aug 23 2003 - 16:12:26 CDT