Aguyngueran wrote:
>>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 ?
yes, sthg command
Received on Sat Aug 23 2003 - 17:14:22 CDT
