The second tip cannot be done on the select query it is needed to be done in the database structure.

So Ai needs to learn the difference between query optimization vs database optimization