which one works faster.
we have 15 million rows. which is a Database of News papers (Articles as
text) for the last year.
We do not insert or delete that records.
Now we are seaching the data with fulltext search.
if we jump to OLAP does the search will give result faster?

Thanks
--
Esref DURNA
Soft. Eng.

OLAP is for faster summaries and aggregations of numeric data, and
category-driven or date-driven analysis. Unless the problem you're solving
is counting occurrences of words (authors, articles), full-text search is
better for what you're doing.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
"Esref DURNA" <esref_durna (AT) microsoft (DOT) com> wrote