Answer 1

Do you use multiple joins? If you join tables without any additional information, the system might search the whole Cartesian product of your tables. And that is a giant search space.

You can use indexes or smart where clauses, so the DBMS can do the optimisations for you. :)