It depends whether you're doing just FTS or also faceted search. In the latter case, you need a completely different kind of index (a covering index with all th

It depends whether you're doing just FTS or also faceted search. In the latter case, you need a completely different kind of index (a covering index with all the filtered fields), and it'll be slow enough to be perceived by the user in the order of 1 million rows.