Gathering Stats In Couchbase

Hi Team,

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.

Thanks,
Debasis

https://www.google.com/search?q=couchbase+cost+base+optimizer+statistics

Both the first and second hits.

Thanks @mreiche for response. I just glanced those two links and did not found anywhere that CB engine gather stats automatically for buckets i:e we need to run the stats manually. Please correct me if I am wrong.

Thanks,
Debasis

Follow the procedure described in the documentation.