Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which conditions are valued by the MaxDB Optimizer?

April 26, 2017Conditions maxdb optimizer Valued

0

Posted

Which conditions are valued by the MaxDB Optimizer?

1 Answer

0

Posted

The Optimizer can use the following search conditions to determine the optimal search strategy: – Equality conditions – Area conditions – IN conditions – Like conditions One-table optimizer Column = value Column <, <=, >=, > value Column BETWEEN value AND value Column IN ( value, value, … ) Column LIKE string value (including %,?,…) Column = (ANY) Column IN Join table optimizer Table1_column = table2_column The search conditions are displayed here in the sequence of their value assignment type. That is, an equality condition on the same column is always better valued than an IN condition under the same conditions. The SQL Optimizer may also reform conditions. If, for example, only one value is repeatedly specified in an IN condition, it converts this condition to an equality condition.