Re: Re: long message list sorted by time
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 21 Jun 2019 12:14:30 +0300
Message-ID: <CAOVevU7M=8uzHbeqngDD59yoQy61HYzLEAd4q=2645Zntkcwbw_at_mail.gmail.com>
Date: Fri, 21 Jun 2019 12:14:30 +0300
Message-ID: <CAOVevU7M=8uzHbeqngDD59yoQy61HYzLEAd4q=2645Zntkcwbw_at_mail.gmail.com>
Hi Lothar,
> Account_name has 2758 distinct values.
Probably it would be better to use manual old-style partition views with
instead-of triggers for that, since NDV of accounts is so small and you are
on SE
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 21 2019 - 11:14:30 CEST