Part of my work at Odoo involves dealing with support questions on a regular basis. One of the common requests is how to improve database performance. Database tuning is a complex subject, and this post won't deal with all the intricacies of this field. But I'll outline a strategy that can yield significant performance gains by simply adding some well chosen indices. The idea is to offer admins without deep database knowledge the information required to speed up their queries without having to wade through reams and reams of documentation.
