Re: Index getting "old" fast

From: Stan Brown <stanb_at_panix.com>
Date: 19 Feb 2002 12:32:11 -0500
Message-ID: <a4u26r$sb4$1@panix1.panix.com>

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:32:11 CST