One of the key thing addressed in Oracle 12.2 optimizer is the ability to perform table elimination (aka join elimination) for relations...