>>> On Fri, Jul 18, 2008 at 2:35 PM, in message
<4744486.108381216409720544.JavaMail.root@mail.featherstoneinformatics.com>,
Sanjay Rajdev <sanjay.rajdev@featherstoneinformatics.com> wrote:
> Thanks for the thought, I think that this can be the problem, as
earlier
> there was no indexing on the column, but 2 days back we added index
on 5 of
> columns in the table and "somedate" is one of them. This problem have
been
> noticed after the index's were added.
> I can't test this out as this happens while people are using the
software,
Try adding another index on the column (with a different index name)
using CREATE INDEX CONCURRENTLY. Then drop the old index.
-Kevin