05.12.2018 12:37, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] 
wrote:
> Could anyone explain me further how the user can go about to effectively
> pick or influence the optimizers decision?

   Join order can be forced by using outer join.
   Using of indexes can be disabled by changing of simple field usage to an 
expression.
   Preferences between ORDER and SORT plans (more commonly between "first row" 
and "all 
rows" strategies) can be changed by using FIRST/ROWS.
   Index statistics recalculation can be done in "a right moment".

-- 
   WBR, SD.
  • [firebird-su... Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
    • Re: [fi... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • RE:... Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]

Reply via email to