OT: SQL Server Full-Text Search issue

2006-01-03 Thread Peterson, Andrew S.
Hi, After the full-text search index process concludes, aren't your "like" queries supposed to be *faster*? Surely I've done nothing wrong :-)... I've created a full text index on my tblReceipts table with 800K records, which took SQL Server 2000 about 6 hours to complete. I selected two colum

OT: SQL Server Full-Text Search issue

2006-01-03 Thread Peterson, Andrew S.
Hello all, After the full-text search index process concludes, aren't your "like" queries supposed to be *faster*? Surely I've done nothing wrong :-)... I've created a full text index on my tblReceipts table with 800K records, which took SQL Server 2000 about 6 hours to complete. I selected t