RE: Index rebuilding
- From: <arul.kumar@xxxxxx>
- To: <steve@xxxxxxxxxxxxxx>
- Date: Fri, 12 Nov 2004 10:53:13 -0000
May be, with the stats up to date CBO "thinks" using a full table scan =
is going to benefit you.
Are you sure those full table scans are REALLY not good?
And, Try INDEX optimizer hint / to keep the execution plan same, you may =
try SQL OUTLINEs
Hope this helps
Arul.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Steve Jelfs
Sent: 12 November 2004 10:45
To: oracle-l@xxxxxxxxxxxxx
Subject: Index rebuilding
We have an index that we need to keep rebuilding in order for the CBO to =
use it. What happens is that we build the index and queries use the=20
index. Then, after a couple of days the CBO reverts to full table=20
scans/. Re-analysing the table and index does not change anything but=20
re-building the index does.
The table holds transient data which is only ever about five days old=20
before it is "archived" off to another table. Wach row might get about=20
2/3 updates during it's short life.
Why might this be? We're using 8.1.7.4 on W2K if that helps!
Cheers
Steve
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
