79113472

Date: 2024-10-22 10:03:36
Score: 1
Natty:
Report link

Try with CTE, so sort should be cheaper eg:

 WITH mydata AS (SELECT a.*,b.date AS bdate 
   FROM a left join b on a.c_id_msg = b.c_id_msg
   WHERE a.c_tar ilike any ('{"AB142%"}') )
 SELECT mydata.* ORDER BY mydata.bdate;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: zeljan