Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

2015-08-15 Thread setysvar setys...@gmail.com [firebird-support]
Den 15.08.2015 06:14, skrev 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]: > Hello Set > > Why writing: PP.STATUS_CODE || '' will improve the SELECT, can you > explain me? > As far I know, adding '' is for use NATURAL in the PLAN, why the use > of NATURAL will d

Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

2015-08-15 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Set I am not who originally post the question, just a curious reader. And I use Firebird 2.5.4 only, I don't like to have several versions because they can have different problems. Just one version for all clients and all servers and all databases, it is the better, according to my point of