Database compatibility is critical to the success of a database product, and it can even make the difference between life and death for a database product. The problem of database compatibility is essentially a problem that software products will have.
The optimizer is the heart and soul of a relational DBMS. It analyzes SQL statements and determines the most efficient access plan for satisfying each statement. For database optimizers, there have always been many voices among database-related practitioners.