Best scenarios where CBO will work efficiently

Hello,
I am learning Couchbase and I would like to explore more on the cost based optimizations. I tried with simple queries to update the statistics, but they don’t show any difference in the performance. Please provide a best example or scenario where CBO will work efficiently.

Hello, can you please clarify what you are talking about when writing CBO, are you talking about Cost Based Optimizer ?