Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT

2023-06-12 Thread Chris Hoover
g well. It’s just an expensive way to get 20 rows and I don’t see an easy way to make it better if that is what is needed. Thanks, Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269 Email: chr...@aweber.com > On Jun 12, 2023, at 5:34 PM, benoit wrote: > > This new index is

Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT

2023-06-12 Thread Chris Hoover
('draft', 'sent') AND sender_reference IN ('Custom/1175', 'Client/362', 'Custom/280') ORDER BY sent_at DESC Thanks, Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269 Email: chr...@aweber.com > On Jun 12, 2023, at 4:17 PM, benoit w

Re: Odd Choice of seq scan

2022-12-02 Thread Chris Hoover
rid FROM orderids JOIN orders USING (orderid); Hope this helps your situation. Thanks, Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269 Email: chr...@aweber.com > On Dec 1, 2022, at 7:52 PM, Paul McGarry wrote: > > Hi there, > > I'm wondering if anyone has an