Coding for effective indexes: Avoid arithmetic expressions

Do not use an arithmetic expression as an operand to be compared to a column in a row selection predicate. The optimizer does not use an index on a column that is being compared to an arithmetic expression. For example, when using SQL, specify the following:

... WHERE SALARY > 16500             

instead of

... WHERE SALARY > 15000*1.1 
 


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]