Re: Index getting "old" fast

do you analyze frequently to keep the access paths etc. up-to-date?

not much of an idea what you're talking about, but just read the previos post and thought I'd suggest that.

analyze table table_name compute statistics for table for all indexed columns for all indexes;

Stan Brown wrote:
>
> In <3C713A5D.108FB148_at_ci.seattle.wa.us> damorgan <dan.morgan_at_ci.seattle.wa.us> writes:
>
> >I can't remember that far back. But if the functionality is there use DBMS_JOB with
> >DBMS_SQL.
>
> >But somehow I find it hard to believe that this is really your problem. What is
> >happening to this table during the 24 hours? How many inserts? How many updates?
> >How many deletes? Is the table being emptied?
>
> about 60 x 24 x 2 inserts.
>
> It's _very_ repatable. Every morning, the queries are back to 20 to 30
> seconds, and droping the index, and recreating it gets them back to 2
> seconds.
>
> Very puzzling.
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Tue Feb 19 2002 - 11:56:19 CST