Minor edit: *if “body” field is indexed=true AND analyzed (i.e. Some text
type; not of type “string”).


On Wed, Jul 28, 2021 at 9:53 PM Rahul Goswami <[email protected]> wrote:

> If ‘body’ field is indexed=true, Shawn’s query should give you results
> where body=“” as well as where body field doesn’t exist at all.
> Also, I agree that the format body:[* TO *] is much faster for high
> cardinality fields (which most likely “body” is).
>
> -Rahul
>
> On Wed, Jul 28, 2021 at 7:46 PM Shawn Heisey <[email protected]> wrote:
>
>> On 7/28/2021 11:48 AM, mtn search wrote:
>> > Thanks Walter, Alex!
>> >
>> > Yes I regularly use -  Search for *:* -body:*
>>
>> That syntax, while it works for finding docs where the body field is
>> entirely missing, is not the best option.  You'll likely find that this
>> syntax is MUCH faster, and returns identical results:
>>
>> *:* -body:[* TO *]
>>
>> The reason it's faster is that * by itself is a wildcard query, and
>> unless the cardinality of the field is very low, those are extremely
>> inefficient.  I would expect a field named "body" to have cardinality in
>> the millions or billions, for sufficiently large indexes.
>>
>> Note that neither of these queries will find docs where the value is the
>> empty string, because I believe that IS matched by either a wildcard
>> query or a range query.
>>
>> Thanks,
>> Shawn
>>
>

Reply via email to