"LeVan,Ralph" wrote:
> How are options 1 and 3 different? They both say that truncation 104 is
> always in effect.
Joe said: "bath.author=Shakespeare, W*" would be preferable to
"bath.authorRT=Shakespeare, W"
"bath.author=Shakespeare, W*" is option 2, where the asterisk in the query
string indicates truncation.
"bath.authorRT=Shakespeare, W" is option 3
Where truncation is part of the "bath.authorRT" definition.
In Option 1 truncation is always assumed in effect and is 104 (implicit
truncation).
So the index definition doesn't specify any truncation (nor does the query
string), because it is always assumed. (In option 3, truncation may be in
effect or it may not, depending on whether the asterisk is included.)
so:
1. Implicit truncation, always 104.
2. Index-defined truncation. Might be 104, might be 100, etc.
3. Explicit truncation. Truncation not necessarily always in effect, but not
specified by the index definition; instead truncation is exposed in the
query string: * in the string means truncation; absence of * means no
truncation.
--Ray
|