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 columns as eligible for full-text queries (using the Full-Text Indexing Wizard), the LastOnlyName being one of them. Shouldn't this query (running from a cf template) take less than 25 seconds? SELECT LastOnlyName, FirstName, SUM(Amount) AS totAmt FROM tblReceipts WHERE (LastOnlyName LIKE '%FORTA%') GROUP BY LastOnlyName, FirstName ORDER BY totamt DESC Thanks in advance for any assistance. Sincerely, Andrew
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
