performance question/multiple keys

Hi All,

The table I'm using has full-text columns and also a date column thats
indexed. If I do a query on a date range and the full-text column does SQL
Server return the full-text rows first, then subset by date, or subset by
date and pass that set of rows to MSSEARCH?

I'm wondering about performance issues on tables with many rows (3 millions
or so). I'm wondering if i should break the data up into tables by day so
that i'm not doing full-text searches if I know that I'll be getting a small
subset according to a date range.

Any insight on this issue?

thanks,

John


.

Relevant Pages

  • Re: Weight returning unexpected results
    ... John, thanks for your reply. ... although now I just ran the same query and I'm getting the results I ... I'll see if I can find anything in the BOL, ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Using AND and OR together in sql
    ... I've tried to make a search an AND OR query ... record with name of John or Paul of age 32 and simply name of John or Paul. ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • extacting first name from a field
    ... the first name in a query. ... So if I have John R. I only want to extract John. ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Count unique values
    ... My Access-97 table looks like this: ... I'd like to make a query which gives me a new table with all unique values ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Still Stuck on Alpha Numerics
    ... >Hi John, I had a thought. ... Could it be that the null values are affecting the ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
Loading