Viewing 2 posts - 1 through 2 (of 2 total)
Yes it has full text indes, but this query:
SELECT Count(TBL_TOC.ID_TOC)
FROM TBL_TOC
WHERE (CONTAINS(BL_TBL_TOC.TEXT, '"test*"'))
takes 10 seconds to run...
It's a very big table with 40,000,000 records!!
January 12, 2012 at 3:56 am
#1432332
Thanks, but I need to do a count with a criteria:
WHERE
(CONTAINS(BL_TBL_TOC.TEXT, '"test*"'))
January 12, 2012 at 3:50 am
#1432328