Example of Lava Operator Tree for Bloom Filters

The lava operator tree indicates the use of bloom filters.

When using the set statistics plancost on command, the bloom filters operator is listed in the lava operator tree. By comparing the actual row count of the child operator and the actual row count of the bloom filter operator, you can calculate how many rows have been filtered out by bloom filter probing.