Re: fragmentation and index maintainence

In article <40ab19e6$0$31674$afc38c87_at_news.optusnet.com.au>, Howard J. Rogers says...
> >
> >
> > Guilty as charged.
>
> Well, that's refreshingly honest, at least!!

Never a reason to be anything but!

<snip details of SQL etc>

>
> Well, this is good because now its facts, though maybe a little off the
> beaten path for this particular thread. It certainly looks as if it
> could be a significant drop in execution time.
>
> Maybe you could start a new thread with this?

New thread started

> Just to be clear, when the
> query is taking 1+ seconds, how long has it been since the last
> drop-and-recreate? And how much DML has the table been subjected to
> since that last drop-and-recreate. Oh, and because I have a memory like
> a goldfish, what O/S and Oracle version is this again?

Approx 2 weeks I think. Probably around 30 inserts/day on average - probably around 400 new / updated records.

8.1.7.4 on Solaris 2.6

-- 

jeremy