join filter - cheeyoung/sqlplus-public GitHub Wiki

id	Operation	Name
	JOIN FILTER CREATE	:BF
	JOIN FILTER USE		SYS_OP_BLOOM_FILTER

 - access(...)
   filter(SYS_OP_BLOOM_FILTER(:BF...,"..."."..."))

• _bloom_filter_enabled

9.4.1 Bloom Filters
9.4.1.4 Bloom Filter Metadata

in the Predicate Information section of the plan, filters that contain functions beginning with the string SYS_OP_BLOOM_FILTER indicate use of a Bloom filter.