>>> On Fri, Jul 18, 2008 at 2:35 PM, in message
<4744486(dot)108381216409720544(dot)JavaMail(dot)root(at)mail(dot)featherstoneinformatics(dot)com>,
Sanjay Rajdev <sanjay(dot)rajdev(at)featherstoneinformatics(dot)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