Re: Oracle 9.2.0.1.0 For Windows performance question

"Ana C. Dent" wrote:

> 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

Of course if that doesn't work the OP might try

CREATE TABLE x AS
SELECT * FROM y;

TRUNCATE TABLE y;

INSERT INTO y
SELECT * FROM x;

DROP TABLE x;

But sthg is far more efficient. Why I used it last night several times after drinking a bit of single malt. And I've had no complaints so far.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)