Thread

Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)

Haowu Ge <gehaowu@bitmoe.com> — 2025-12-24T10:05:35Z

On 12/24/25 15:50, Richard Guo wrote:
> On Thu, Dec 18, 2025 at 5:56 PM Richard Guo <guofenglinux@gmail.com> wrote:
>> Upon closer look, it seems that we do not need the syntactic scope
>> check at all, as long as we ensure that phnullingrels is empty.  In
>> this case, the PHV is either a no-op (from a reduced outer join) or
>> used for identity separation (grouping sets).  In either case, the PHV
>> is transparent regarding the value, so it should not prevent the
>> underlying expression from matching the index.
> 
> Here is the updated version along the lines of this idea.
> 
> - Richard

Tested and passed in both example and production environments. Thank you 
for your work.

-- 
Thanks & Best Regards
👨‍💻 Haowu Ge (葛豪武) | 🌐 www.gehaowu.com | 📡 BG5FRG | 🔐 0xDF09D8A8