Indexing problem

kjimenez

Hello, I am having issue

The following query returns over 1 million records on our SQL DB

select count(*)from dmi_queue_item_s(nolock) where name='dm_fulltext_index_user'

I believe this is the case because indexing was down on the weekend and a job we run causes reconcilliation (ftintegrity)to run over and over with the docbase and indexing server.

I want to delete out all records and then manually run ftintegrity. Is the easiest way to directly delete through SQL? This is taking forever, I think it will take over 24 hrs to complete. Any ideas? I remember I thought there was a way to easily clear out the queue. Thanks.

DCTM_Guru

SQL would be the fastest.  You may want to configure/script the SQL to delete in batches.  I remember we had problems trying to a perform a very large bulk delete in Oracle.  Oracle was trying to copy the entries in rollback table and this causing the database to come to crawl.