Re: Re: Re: long message list sorted by time

Hi Sayan,
that would be correct if account would really be the only search criteria. As I wrote it is a simplification . , there are 5 other search criteria. In addition think about the size of one partition. Not so helpful, really.
Thanks and Regards
Lothar
----Ursprüngliche Nachricht----
Von : xt.and.r_at_gmail.com
Datum : 21/06/2019 - 11:14 (MS)
An : l.flatz_at_bluewin.ch
Cc : andysayer_at_gmail.com, oracle-l_at_freelists.org Betreff : Re: Re: long message list sorted by time     

   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-l