query language description with samples

[Sven Erik Matzen]

Do you know some description of the query language? I've tried the MSDN -
and was "not amused", again. It's saying that $[fieldname] does a fulltext
search, @[fieldname] does a value search. Having this information I was
assuming that a search for all the words "a", "b" and "c" inside "Content"
OR "Title" should be like this:
((@Contents CONTAINS "a") &
(@Contents CONTAINS "b") &
(@Contents CONTAINS "c")) | (
(@Title CONTAINS "a") &
(@Title CONTAINS "b") &
(@Title CONTAINS "c"))

I don't want the "fuzzy" search of index server here, I just want it to find
the words I've specified - nothing more. Also I want to search for documents
containing all words starting with "a", "b" and "c" inside "Content" OR
"Title". That means in SQL:
SELECT * From Documents where
(Content Like "% a%" AND
Content Like "% b%" AND
Content Like "% c%") OR
(Title Like "% a%" AND
Title Like "% b%" AND
Title Like "% c%")

Also I ask myself how to query the index server in a "fast" way. Performance
is a great deal in our company and for SQL server I know how to optimize my
queries, but for index server ...
I currently assume that "@" may be faster than "$" and "#" (regular
expressions) should be even slower, but I may be wrong (e.g. if index server
internally always uses regular expressions and needs to "convert" @ and $
searches to # before starting the search).

CU,

Sven

[david lee]

Content queries (@) are the fastest. Then freetext ($), then regular
expressions (#).

"Sven Erik Matzen" <sven....@ppepro.com> wrote in message
news:ObxhumVO...@TK2MSFTNGP12.phx.gbl...