[PERFORM] Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison

[林士博]

I think you should try putting the precomputed boolean temp_eval column
to "EXTERNAL_TRANSLATION" r table.

And if possible, try creating a conditional index on id where temp_eval is
true,
on "EXTERNAL_TRANSLATION" r table.

So that, only check this index can get the top 1000 records.