Re: Huge Tables

2023-03-13 Thread André Rodrigues
Thanks a Million for your tips ! Very very good ! Em seg., 13 de mar. de 2023 às 12:45, Rick Otten escreveu: > 300M rows isn't "huge", but it is starting to get to be real data. > > Some notes/very general rules of thumb since you asked a very general > question: > 1. Consider updating the

Re: Huge Tables

2023-03-13 Thread Rick Otten
300M rows isn't "huge", but it is starting to get to be real data. Some notes/very general rules of thumb since you asked a very general question: 1. Consider updating the statistics on the table from the default sample of 100 rows to something larger - especially if you have a wide variety of da