Hey All, I have a query like below
SELECT * FROM data WHERE val=trunc(val) AND acc_id='kfd50ed6-0bc3-44a9-881f-ec89713fdd80'::uuid ORDER BY ct DESC LIMIT 10; table structure is data (id uuid, c_id uuid, acc_id uuid, val numeric, ct timestamptz); Can you please help me to write an index? or Can someone write an index and revert here.. its very urgent for me. Thanks -- Thanks, Chanukya SDS +918186868384 Sent From My iPhone
