In Couchbase 7.1 there is option to choose to use Cost based Optimizer. As we know in RDBMS technology with out stats collection the optimizer will not choose a good plan in case CBO. So our concern is how to gather stats for the buckets is it automatic or we need to write some scripts to do it. What are the best practices while gather stats.
Please share us any documentation link or blog reference to follow the same.