OAK TREE HEALTH PLAN

Brand	Owner	Address	Description
OAKTREE HEALTH PLAN	HEALTH RISK MANAGEMENT, INC.	10900 Hampshire Ave. S Bloomington MN 554382306	OAK TREE HEALTH PLAN;[underwriting insurance for pre-paid health care];HEALTH PLAN;health care in the nature of health maintenance organizations;
	Where the owner name is not linked, that owner no longer owns the brand

Technical Examples

An apparatus, program product and method utilize a query optimizer that identifies Join types in a query plan that can be replaced to facilitate optimization of the plan. If the query plan is considered to have a tree-graph representation, then the optimizer locates Join nodes to be replaced and substitutes an Inner Join node and additional nodes that do not inhibit optimization strategies and algorithms. As a result, all Outer Joins, whether left or right, and all Exception Joins, whether left or right, can be removed from the query plan before performing optimizations such as predicate movement, GROUP BY movement, ORDER BY movement, and Join enumeration.