Re: Index problem Need an urgent fix

hi, Le ven. 3 févr. 2023 à 11:33, chanukya SDS a écrit : > 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, > a

Re: Index problem Need an urgent fix

On Fri, Feb 3, 2023 at 9:03 AM chanukya SDS wrote: > > 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 uui