Switch to: V12V11V10V9V8V7V6V5

Table Method vs SQL Hints

Table Method of Valentina Database (aka Calculated Field) allows you to specify it in SQL directly by name and in this way to choose index.

Some other databases can do this via additional HINT in the SQL command, provided as

  • some comment of special format, e.g. Oracle.
  • extension of SQL, e.g. MS SQL.

Advantage: is that you have LESS CODE.


Valentina DB:

SELECT employee_id, department_id 
  FROM employees 
  WHERE department_id_ix > 50;

vs some other DB:

SELECT /*+ INDEX (employees emp_department_ix)*/ 
       employee_id, department_id 
  FROM employees 
  WHERE department_id > 50;

Note in the first command usage of department_id_ix calculated field in the WHERE clause.