luapfr
luapfr
Any position? I just downloaded the latest version and the SQL code completer doesn't save the size
Any position ?
The problem with your approach is that I need to use "Left Join" fields and with your approach I can't How would I execute this code with "Exists" SELECT CM.Codigo,...
I changed the SQL of the initial Post because I need access to "Left Join" fields and using "Exists" I don't have that type of access
I can't join the same table, there have to be two "Left Joins". This example I posted is very simple, the complete SQL is much more complex and I actually...
How strange, I created the indexes and here it takes more than 20 minutes CREATE INDEX CADASTRO_MERCADORIAS_I1 ON CADASTRO_MERCADORIAS (CODIGO, MERCADORIA); CREATE INDEX ESTOQUE_I1 ON ESTOQUE (COD_MERCADORIA); Are you sure...
> These are your data transmitted via mega. > Creating the two indexes shouldn't have taken more than a few seconds. > The server used is an old xeon with...
> > The problem is the SQL execution that takes 20 minutes > > Without these indexes (or at leas one index on Cod_Mercadoria) it is not Firebird problem but...
> Probably the statistics on your existing indexes are out of date. For people who restored your backup, they are up to date. You may want to consider restoring the...